SQL>
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='c99yw1xkb4f1u';
ADDRESS HASH_VALUE
---------------- ----------
0000000064E29800 1689401402
SQL> exec DBMS_SHARED_POOL.PURGE ('0000000064E29800,1689401402','C');
PL/SQL procedure successfully completed.
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='c99yw1xkb4f1u';
no rows selected
SQL>
No comments:
Post a Comment