oracle监控数据库慢 sql

1.查询执行最慢的sql’

   select * 
   from(select 
          sa.sql_text,
          sa.sql_fulltext,sa.executions "执行次数", 
          round(sa.elaosed_time/1000000,2) "总执行时间",
          round(sa.elapsed_time/1000000/sa.executions,2) "平均执行时间",
          sa.command_type,sa.parsing_user_id "用户id",
          u.username "用户名",
          sa.hash_value 
       from v$sqlarea sa 
       left join all_users u on sa.parsing_user_id = u.user_id 
       where sa.executions >0 
       order by (sa.elapsed_time/sa.executions) desc) 
    where rownum <=50;

2.查询次数最多的sql’

 select * 
 from (select 
          s.sql_text,s.executions "执行次数",
          s.parsing_user_id "用户id",
          u.username "用户名",
          rank() over(order by executions desc) exec_rank     
          from v$sql s   
          left join all_users u on u.user_id = 
          s.parsing_user_id) t 
where exec_rank <=100;