Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| oracle_sql_processing [2020/10/19 07:27] – [SQL Processing] 86.49.253.137 | oracle_sql_processing [2020/10/19 07:29] (current) – 86.49.253.137 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| =====Overview===== | =====Overview===== | ||
| - | The SQL processing like any other processing of code. It comes from a human and needs to go back to a human :) The problem is, through how many stops it will pass. | + | The SQL processing like any other processing of code. It comes from a human and needs to go back to a human :) The problem is, through how many stops it will pass |
| Below you can see a basic representation on the possible wait times for any query: | Below you can see a basic representation on the possible wait times for any query: | ||
| Line 33: | Line 33: | ||
| [[oracle_sql_processing_parse| Parsing]] | [[oracle_sql_processing_parse| Parsing]] | ||
| * Open Cursor | * Open Cursor | ||
| - | * Syntax Check: If the query' | + | * Syntax Check |
| - | * Semmantic Check: If you have the right to access the related objects. | + | * Semmantic Check |
| - | * [[oracle_sql_processing_shared_pool_check| Shared Pool check]]: If the plan isn't stored in the shared pool already. | + | * [[oracle_sql_processing_shared_pool_check| Shared Pool check]] |
| * Binding | * Binding | ||
| * *Optimization | * *Optimization | ||
| Line 47: | Line 47: | ||
| * Close Cursor | * Close Cursor | ||
| - | *-Optional steps in case of hard parse | + | *- Only when hard parse is needed |