conn / as sysdba
1)
alter system flush shared_pool; --- not recommend during the peak hours of the prod..
or,
2)
select sql_text,address, hash_value, executions from v$sqlarea where sql_id = '&sqlid';
exec sys.dbms_shared_pool.purge('&address, &hash_value','c');
-- passing the address and hash_value from the previous query
相关文章
- 10-02flush sqlid shared_pool
- 10-02cin流输入控制(clear(),sync(),flush(),ignore())
- 10-02qt: flush: BitBlt failed
- 10-02Python 文件 flush() 方法
- 10-02Hibernate的clear(),flush(),evict()方法详解
- 10-02脏页flush和收缩表空间
- 10-02xlog flush request is not satisfied in log files
- 10-02innodb_flush_log_at_trx_commit参数
- 10-02HBase – Memstore Flush和flush shell操作 深度解析
- 10-02ctrl+c以及写操作失败和flush