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 [2019/08/14 10:13] – [Calls] andonovj | 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 9: | Line 9: | ||
| =====Calls===== | =====Calls===== | ||
| Before we start speaking of SQL processing, we should discuss something very important and that is how ORACLE communicate and operate in general. | Before we start speaking of SQL processing, we should discuss something very important and that is how ORACLE communicate and operate in general. | ||
| - | Oracle kernel is using requests called " | + | Oracle kernel is using requests called " |
| DB Calls: | DB Calls: | ||
| Line 47: | Line 47: | ||
| * Close Cursor | * Close Cursor | ||
| - | *-Optional steps in case of hard parse | + | *- Only when hard parse is needed |