oracle慢查詢的方法：1、查詢執(zhí)行最慢的sql，代碼為【on sa.PARSING_USER_ID = u.user_id】；2、查詢次數(shù)最多的sql，代碼為【on u.USER_ID = s.PARSING_USER_ID) t】。

oracle慢查詢的方法：

Oracle沒有像MySql那樣同時設(shè)置參數(shù)來分析慢查詢，然而卻提供了慢查詢的sql語句，此Sql語句需要通過dba權(quán)限的帳號登錄進行查詢

1.查詢執(zhí)行最慢的sql

select *  from (select sa.SQL_TEXT,         sa.SQL_FULLTEXT,         sa.EXECUTIONS "執(zhí)行次數(shù)",         round(sa.ELAPSED_TIME / 1000000, 2) "總執(zhí)行時間",         round(sa.ELAPSED_TIME / 1000000 / sa.EXECUTIONS, 2) "平均執(zhí)行時間",         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 where u.username='填寫同戶名'      order by (sa.ELAPSED_TIME / sa.EXECUTIONS) desc)  where rownum <= 50;#查詢的數(shù)據(jù)數(shù)目

2.查詢次數(shù)最多的sql

select *  from (select s.SQL_TEXT,         s.EXECUTIONS "執(zhí)行次數(shù)",         s.PARSING_USER_ID "用戶名",         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;

相關(guān)學(xué)習(xí)推薦：oracle數(shù)據(jù)庫學(xué)習(xí)教程