监控数据库性能的SQL汇总笔记

监控数据库性能的SQL汇总笔记贴出部分内容：1.监控事例的等待selectevent,sum(decode(wait_Time,0,0,1))"Prev",sum(decode(wait_Time,0,1,0))"Curr",count(*)"Tot"fromv$session_Waitgroupbyeventorderby4;2.回滚段的争用情况selectname,waits,gets,waits/gets"Ratio"fromv$rollstata,v$rolln