摘要: 常用的一些性能查询sql语句--查看表锁select * from sys.v_$sqlarea where disk_reads>100--监控事例的等待select event, sum(decode(wait_Time, 0, 0, 1)) "Prev", sum(decode(wait_Time, 0, 1, 0)) "Curr", count(*) "Tot" from v$session_Waitgroup by eventorder by 4--回滚段的争用情况select name, waits, gets, w 阅读全文
posted @ 2011-01-21 18:14 蓝紫 阅读(3741) 评论(1) 推荐(1) 编辑