监控 SQL 1.监控事例的等待： select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*) from v$session_wait group by event order by 4; 2.回滚段的争用情况： select name,waits,gets,waits/gets ratio from v$rollstat a,v$rollname b where a.us
1. Everything简介 Everything是voidtools开发的一款文件搜索工具，官网描述为“基于名称实时定位文件和目录（Locate files and folders by name instantly）”。它体积小巧，界面简洁易用，快速建立索引，快速搜索，同时占用极低的系统资源，实时跟踪文件变化，并且还可以通过http或ftp形式分享搜索。 2. Everything三大优点 2.1 速度极快 Everything搜索工具的最大优点是速度极快。 第一个快速体现在索引速度。官
监控数据库性能的SQL汇总笔记贴出部分内容：1. 监控事例的等待 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; 2. 回滚段的争用情况 select name, waits, gets, waits/gets "Ratio" from v$roll
