8 Mart 2012 Perşembe

[EN] PIN, UNPIN, PURGE SQL FROM SHARED POOL

select address||','||hash_value from v$sqlarea where sql_id = 'd12dc094hz335';

exec sys.dbms_shared_pool.keep   ('00000003CB2559C0,1225755749','C',1);
exec sys.dbms_shared_pool.unkeep ('00000003CB2559C0,1225755749','C',1);
exec sys.dbms_shared_pool.purge  ('00000003CB2559C0,1225755749','C',1);

Hiç yorum yok:

Yorum Gönder