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_shared_pool_check [2019/08/11 20:59] – andonovj | oracle_sql_processing_shared_pool_check [2019/10/18 20:04] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| =====Overivew===== | =====Overivew===== | ||
| + | During this step, the engine is checking if the SQL has already generated execution plan. This is accomplished by hashing the SQL TEXT into a hash code, which in turn is being crosscheck with the shared pool. | ||
| + | {{ : | ||
| - | {{ : | + | If the check, returns true, then depending on the adaptive cursor sharing valie, the execution plan might or might not be used. If it isn't used at all or doesn' |