oracle执行sql超慢,046 Oracle执行慢的SQL

标签：

1 -- 执行最慢的sql

2 SELECT *

3 FROM (SELECT sa.SQL_TEXT,

4 sa.SQL_FULLTEXT,

5 sa.EXECUTIONS as "exeCount",

6 ROUND(sa.ELAPSED_TIME / 1000000, 2) as "execTimeTotal",

7 ROUND(sa.ELAPSED_TIME / 1000000 / sa.EXECUTIONS, 2) as "execTimeAvg",

8 sa.COMMAND_TYPE,

9 sa.PARSING_USER_ID,

10 u.username,

11 sa.HASH_VALUE

12 FROM v$sqlarea sa

13 LEFT JOIN all_users u

14 ON sa.PARSING_USER_ID = u.user_id

15 WHERE sa.EXECUTIONS > 0

16 ORDER BY (sa.ELAPSED_TIME / sa.EXECUTIONS) DESC)

17 WHERE rownum <= 50;

标签：

来源： https://www.cnblogs.com/juncaoit/p/10210544.html