摘要:
1,清除缓存alter system flush buffer_cache/ALTER SYSTEM FLUSH SHARED_POOL--buffer_cache 数据緩存--SHARED_POOL 共享池内存执行过的Sql查询select * from (select substr(sql_text,1,4000) "stmt", count(*),sum(sharable_mem) mem,min(module) dear,max(module) from v$sql where 1=1group by substr(sql_text,1,4000)order by 阅读全文
posted @ 2013-02-18 15:49
走遍江湖
阅读(698)
评论(0)
推荐(0)