ON CALL DBA SUPPORT

— Database blog

FLUSING THE SINGLE SQL STATEMENT FROM THE SHARED POOL

Posted by ssgottik on 12/06/2015

FLUSING THE SINGLE SQL STATEMENT FROM THE SHARED POOL:

Till 10.2.0.2:
————–
SQL > ALTER SYSTEM FLUSH SHARED_POOL;

In 10.2.0.4:
————
The enhanced DBMS_SHARED_POOL package with the PURGE procedure is included in the 10.2.0.4 patchset release.

NOTE : RDBMS patch 5614566

FROM 11g:
———
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID = ‘9k2thjfjykcb%’;

ADDRESS HASH_VALUE
—————- ———-
000000085FD77CF0 808321886

SQL> exec DBMS_SHARED_POOL.PURGE (‘0000000090DA1C68, 809121806’, ‘C’);

PL/SQL procedure successfully completed.

SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like ‘9k2thjfjykcb%’;

No rows selected

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: