oracle存储过程执行慢 ORACLE如何查看执行时间较长较慢的语句?

ORACLE如何查看执行时间较长较慢的语句?运行慢的sql:select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, sa.E

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