Summary of oracleSQL parsing steps

OracleSQL parsing steps, oracle-loving friends can refer to, learn about the workflow.

Oracle SQL parsing steps, oracle-loving friends can refer to, learn about the workflow.

1 The syntax of the SQL statement is verified.

SQL syntax check

2 The data dictionary is searched to verify table and column definitions.

Checklist name and field name from data dictionary

3 The data dictionary is searched to verify security privileges on relevant objects.

Check permissions from data dictionary

4 Parse locks are acquired on the relevant objects.

Resolve the Lock of related objects

5 The optimal execution plan is determined.

Select to run the SQL statement in the execution plan

6 The statement is loaded into the shared SQL area (also known as the library cache) in the shared pool of the system global area (SGA ).

After execution, the SQL statement is placed in the SQL sharing area of SGA.