摘要:
陈高峰原创基本都是工作中常用,性能优化和管理必备的sql;--1.查看表锁 select * from sys.v_$sqlarea where disk_reads>100;--2.监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order by 4;--3.性能最差的SQLSELECT * 阅读全文
posted @ 2012-06-26 17:22 Golf工作室 阅读(255) 评论(0) 推荐(0) 编辑