Oracle COMMIT statement processing sequence

The Oracle COMMIT statement is expected to help you understand it. The following describes how to process the Oracle COMMIT statement.

Oracle COMMIT statement processing sequence
When a transaction is committed, Oracle assigns a unique sequence Number SCN (System Change Number) to the transaction. The database is always restored Based on the SCN number. The SCN number is recorded in the control file, data file, block header, and redo log file.

1. Oracle COMMIT statement processing steps:

Oracle submits transactions in the following cases:

L issue a COMMIT statement.

L when executing DDL statements.

L when leaving Oracle.

The order in which Oracle processes COMMIT is:

1) The server generates an SCN for each COMMIT. Make changes permanent.

2) The LGWR process writes the log buffer data with SCN to the redo log file.

3) The server releases table-level and row-level locks.

4) The user is prompted that the COMMIT is complete.

5) The server has completed the transaction.

The order in which Oracle processes ROLLBACK is:

Perform rollback when the following conditions occur:

L issue the ROLLBACK command.

L the server process is terminated unexpectedly.

L The session is terminated by the DBA.

ROLLBACK is used to undo database operations by performing the following steps:

1) the server process is not changed.

2) The server releases table-level and row-level locks.

3) The server has completed the transaction.
 

Complete Oracle File System Parsing

ORACLE system table and data dictionary View

In-depth analysis of Oracle ERP system module

Detailed explanation of four categories of Oracle index Scanning

Implementation of Oracle's fixed number of records