找到耗CPU比较高的语句

SELECT *
  FROM (SELECT HASH_VALUE,
               SQL_TEXT,
               b.MACHINE,
               SUM(A.EXECUTIONS) EXECUTIONS,
               SUM(A.PARSE_CALLS) PARSE_CALLS,
               SUM(A.CPU_TIME) CPU_TIME,
               SUM(A.DISK_READS) DISK_READS,
               SUM(A.DISK_READS) / SUM(A.EXECUTIONS) DISK_EXEC,
               SUM(A.CPU_TIME) / SUM(A.EXECUTIONS) CPU_EXEC
          FROM V$SQLAREA A, v$session b 
         WHERE A.EXECUTIONS <> 0
         AND SQL_TEXT NOT LIKE 'DECLARE%'
         AND a.HASH_VALUE = b.SQL_HASH_VALUE
         AND b.STATUS = 'ACTIVE'
         GROUP BY HASH_VALUE, SQL_TEXT,MACHINE
         ORDER BY CPU_EXEC DESC)
 WHERE EXECUTIONS > 1
 AND CPU_EXEC>500000;