DB 부하율 검색 쿼리 (1등하면 안좋은것..)

경고! 

쿼리 실행시 기존에 사용한 쿼리문을 모두(또는 일부) 돌린후 쿼리 끼리 검증 함으로 반드시 일반 사용자가 사용하지 않은 시간에 돌려야 합니다. 

SELECT *
FROM (SELECT                                 /*+ LEADING(u) USE_HASH(u s) */
S.SQL_ID
,S.MODULE
,RANK () OVER (ORDER BY CPU_TIME DESC) CPU_USAGE_RANK
,NVL (RATIO_TO_REPORT (CPU_TIME) OVER (), 0) CPU_USAGE_RATIO
,SQL_FULLTEXT
,EXECUTIONS
,ROWS_PROCESSED
,ROUND (
DECODE (EXECUTIONS
,NULL, 0
,0, 0
, (NVL (ELAPSED_TIME, 0) / EXECUTIONS) / 1000000)
,5)
ELAPSED_PER_EXEC
,ROUND (
DECODE (
EXECUTIONS
,NULL, 0
,0, 0
, (NVL (
CLUSTER_WAIT_TIME
+ USER_IO_WAIT_TIME
+ CONCURRENCY_WAIT_TIME
+ APPLICATION_WAIT_TIME
,0)
/ EXECUTIONS)
/ 1000000)
,5)
WATI_TIME_PER_EXEC
,ROUND (
DECODE (EXECUTIONS
,NULL, 0
,0, 0
, (NVL (CPU_TIME, 0) / EXECUTIONS) / 1000000)
,5)
CPU_TIME_PER_EXEC
,ROUND (
DECODE (
EXECUTIONS
,NULL, 0
,0, 0
, (NVL (CLUSTER_WAIT_TIME, 0) / EXECUTIONS) / 1000000)
,5)
CLUSTER_WAIT_PER_EXEC
,ROUND (
DECODE (
EXECUTIONS
,NULL, 0
,0, 0
, (NVL (USER_IO_WAIT_TIME, 0) / EXECUTIONS) / 1000000)
,5)
USER_IO_WAIT_PER_EXEC
,ROUND (
DECODE (
EXECUTIONS
,NULL, 0
,0, 0
, (NVL (CONCURRENCY_WAIT_TIME, 0) / EXECUTIONS) / 1000000)
,5)
CONCURRENCY_WAIT_PER_EXEC
,ROUND (
DECODE (
EXECUTIONS
,NULL, 0
,0, 0
, (NVL (APPLICATION_WAIT_TIME, 0) / EXECUTIONS) / 1000000)
,5)
APPLICATION_WAIT_PER_EXEC
,ROUND (
DECODE (EXECUTIONS
,NULL, 0
,0, 0
, (NVL (BUFFER_GETS, 0) / EXECUTIONS))
,0)
BUFGETS_PER_EXEC
,ROUND (
DECODE (BUFFER_GETS
,0, 1
, (BUFFER_GETS - DISK_READS) / BUFFER_GETS)
,1)
BUF_HIT_RATIO
,CPU_TIME
,ELAPSED_TIME
,CLUSTER_WAIT_TIME
,USER_IO_WAIT_TIME
,CONCURRENCY_WAIT_TIME
,APPLICATION_WAIT_TIME
,PARSE_CALLS
,DISK_READS
,BUFFER_GETS
,FETCHES
,PLSQL_EXEC_TIME
,JAVA_EXEC_TIME
FROM DBA_USERS U, GV$SQL S
WHERE S.PARSING_USER_ID > 5 AND S.PARSING_USER_ID = U.USER_ID)
WHERE CPU_USAGE_RANK <= 100;