Difference between database transaction processing in SQL and oracle

[Kalanidhi]

Hi all,

I am a database admin in one company. Database Transaction is a set of database operations of the processing units. But i am confused that what i am using SQL or oracle in Database Transaction. Can anybody clarify the difference between database transaction processing in SQL and oracle. Thanks in advance.

[Praetor]

In SQL Server 2008 transaction types, Automatically commit the transaction Auto commit Transactions. This is the SQL Server default transaction types, each a single SQL statement (SQL statement) is a separate transaction, the statement after the implementation of auto-commit. The caller does not require manual control transaction flow. It can also shows Affairs Explicit Transactions. The caller need to call the API or by using T-SQL of the BEGIN TRANSACTION statement to open the transaction. You need to call to submit a COMMIT or ROLLBACK TRANSACTION or rolled back. All the best.

[Katty]

Oracle transaction processing type of a bit like a SQL Server the implicit transaction. When the execution to the first executable SQL statement automatically open the transaction, and then need to call the parties to submit the implementation of commit or rollback or roll back the transaction, if there is DDL statement, Oracle will automatically be submitted matters. The structure of the Oracle logical and physical differences. Logical structure is a table space, while the physical structure is a data file. Check and reply.

[kelfro]

Use the SET IMPLICIT_TRANSACTIONS ON the implicit transaction model to a model. The caller does not require the implementation of BEGIN TRANSACTION statement to open the transaction. The implementation of the database engine to automatically open when the SQL statement transaction. Need to call the caller to submit a COMMIT or ROLLBACK TRANSACTION or rolled back. When the database engine to the next SQL statement Shiyou automatically open a new transaction. but in oracle the concept id difference. Check and reply.

[Zecho]

Oracle achieve affairs is logically achieved by the Undo Table space. Undo Table space contains the Undo Segments, while the Undo Segement includes Undo Data. Undo Data to support the transaction logic unit. Undo Data used to save the data before and after modification to support the rollback, long queries, and the flashback queries, and failed transaction recovery functions. Thanks to Undo Data, roll back the transaction easier, because the Undo Data saved the data before and after modification to ensure transaction atomicity. Failed transaction recovery and transaction rollback is similar, when the Network Interruption, or other causes abnormal transaction stop Database the engine can be recovered to a consistent state. Best of luck.

[Reegan]

We must know is that different databases of different transaction types, such as MS SQL Sever is the default is automatically commit the transaction, using the time you need to know each statement has a separate transaction in operation. The Oracle is similar to the implicit transaction, you must manually commit or rollback. Also, the use affairs to know one correspondence, especially in nested transaction time, beginnings and ends. A lot of problems when the time of the year-end, pay attention to exception handling need to end the transaction has been opened. Check and reply.