Menu
Suppose an update is made through a transaction, and then a commit statement is issued.
Which are all the internal processes are that happen under the hood in an Oracle server, after a commit statement?
851
A commit is used on a transaction to apply it into the database which means the database is altered. It can be used implicitly as well as explicitly. A transaction is an atomic unit which consists of one or more logical unit.
The commit statement terminates the current database transaction and commits any changes made by the transaction. After you issue a commit statement, you cannot undo (roll back) any changes to the database made by the committed transaction. A commit statement also closes any open cursors.
4. COMMIT statement permanently save the state, when all the statements are executed successfully without any error. In ROLLBACK statement if any operations fail during the completion of a transaction, it cannot permanently save the change and we can undo them using this statement.
An automatic commit occurs under the following circumstances: – A DDL statement is issued. – A TCL statement is issued. when there is a system failure.
177
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
