刷新共享池游标的两种方法

--特定游标对象

SELECT ADDRESS, HASH_VALUE, EXECUTIONS, PARSE_CALLS
FROM V$SQL
WHERE SQL_ID = '7q9wc51p34my2';

00000007A4E9E040 1781682114 289583 289583

ALTER SESSION SET EVENTS '5614566 trace name context forever';

BEGIN
  dbms_shared_pool.purge('00000007A4E9E040,1781682114','C');
END;
/

ALTER SESSION SET EVENTS '5614566 trace name context off';

 

--表相关游标对象
BEGIN
  DBMS_STATS.GATHER_TABLE_STATS(OWNNAME          => 'username',
                                TABNAME          => 'tabname',
                                ESTIMATE_PERCENT => 100,
                                METHOD_OPT       => 'for all columns size skewonly',
                                CASCADE          => TRUE,
                                NO_INVALIDATE    => FALSE);  --使相关游标失效
END;
/