定位SQL的内存地址
定位到影响数据库性能SQL的内存地址,从内存中刷出执行计划
select address,hash_value,
executions,parse_calls
from v$sqlarea where
sql_id='4ca86dg34xg62';
--清除出内存
exec sys.dbms_shared_pool.purge('C000000A4C502F40,4103674309','C');
select address,hash_value,
executions,parse_calls
from v$sqlarea where
sql_id='4ca86dg34xg62';
--清除出内存
exec sys.dbms_shared_pool.purge('C000000A4C502F40,4103674309','C');