色婷婷狠狠18禁久久YY,CHINESE性内射高清国产,国产女人18毛片水真多1,国产AV在线观看

ORACLE如何查看執行時間較長較慢的語句

劉柏宏2年前16瀏覽0評論

ORACLE如何查看執行時間較長較慢的語句?

運行慢的sql:

select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, 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;