oracle如何慢查詢？

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?&gt;?0?where?u.username='填寫同戶名' ?????order?by?(sa.ELAPSED_TIME?/?sa.EXECUTIONS)?desc) ?where?rownum?<p>2.查詢次數最多的sql</p><pre class="brush:php;toolbar:false">select?* ?from?(select?s.SQL_TEXT, ????????s.EXECUTIONS?"執行次數", ????????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?<blockquote><p>相關學習推薦：<a href="https://www.php.cn/oracle/" target="_blank">oracle數據庫學習教程</a></p></blockquote>