Show pageOld revisionsBacklinksODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. =====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. {{ :sharedpoolcheck.jpg?500 |}} 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't exist, then a HARD PARSE is performed. oracle_sql_processing_shared_pool_check.txt Last modified: 2019/10/18 20:04by 127.0.0.1