Oracle Flush Shared Pool

–flush the whole shared pool
alter system flush shared_pool;

— flush a single execution plan
select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like ‘7yc%’;

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

exec DBMS_SHARED_POOL.PURGE (‘000000085FD77CF0, 808321886’);

https://blogs.oracle.com/mandalika/entry/oracle_rdbms_flushing_a_single
http://kerryosborne.oracle-guy.com/2008/09/flush-a-single-sql-statement/
http://www.dba-oracle.com/10g_flush_shared_pool.htm
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_shared_pool.htm

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