Purge cursor value from shared_pool
Okay, please use the following steps to purge the cursor from the shared pool and then see what occurs from there.
select address, hash_value from v$sqlarea where sql_id = '&sql_id';
ADDRESS HASH_VALUE
-------- ----------
2671F27C 3599690174 <<<< Example Output>> !! You will need to use the above query to get the proper address and hash_values !!
SQL> exec dbms_shared_pool.purge('&address,&hash_value','C')
you can add any hint to sql annd execute it to hard parse
like
/*+ hint heyhey */
Okay, please use the following steps to purge the cursor from the shared pool and then see what occurs from there.
select address, hash_value from v$sqlarea where sql_id = '&sql_id';
ADDRESS HASH_VALUE
-------- ----------
2671F27C 3599690174 <<<< Example Output>> !! You will need to use the above query to get the proper address and hash_values !!
SQL> exec dbms_shared_pool.purge('&address,&hash_value','C')
you can add any hint to sql annd execute it to hard parse
like
/*+ hint heyhey */
No comments:
Post a Comment