Oracle SQL parsing steps Summary _oracle

1 The syntax of the SQL statement is verified.

syntax checking for SQL

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

Check table name and field name from data dictionary

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

Check permissions from the data dictionary

4 Parse locks are acquired on the relevant objects.

Resolving locks on related objects

5 The optimal execution is determined.

Select Run SQL in execution plan

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

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