Last active
April 29, 2019 11:34
-
-
Save kotlas92/a3432e5391ba0e6c3008c09b9dd7d8d6 to your computer and use it in GitHub Desktop.
Oracle flush execution plan
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '7yc%'; | |
ADDRESS HASH_VALUE | |
---------------- ---------- | |
000000085FD77CF0 808321886 | |
SQL> exec DBMS_SHARED_POOL.PURGE ('000000085FD77CF0, 808321886', 'C'); | |
PL/SQL procedure successfully completed. | |
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '7yc%'; | |
no rows selected |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment