ORACLE慢sql查询脚本

星辰淼

已于 2024-07-26 17:52:47 修改

阅读量206

点赞数 8

文章标签： oracle sql 数据库

于 2024-07-22 20:00:00 首次发布

本文链接：https://blog.csdn.net/HJ_20210519/article/details/140611895

版权

select *
 from (select sa.SQL_TEXT,
  sa.PLSQL_EXEC_TIME,
        sa.SQL_FULLTEXT,
        sa.last_active_time,
        sa.EXECUTIONS "执行次数",
        round(sa.ELAPSED_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;