![](https://csdnimg.cn/release/download_crawler_static/86976142/bg4.jpg)
PPT
PPT
文
文
档
档
演
演
模
模
板
板
Office
Office
PPT
PPT
按
按
照
照
使
使
用
用
资
资
源
源
列
列
出
出
100
100
个
个
-- Get the top 100 queries by total number of disk_reads_delta by
-- Get the top 100 queries by total number of disk_reads_delta by
execution
execution
SELECT *
SELECT *
FROM (SELECT SQL_ID,
FROM (SELECT SQL_ID,
CASE SUM(EXECUTIONS_DELTA)
CASE SUM(EXECUTIONS_DELTA)
WHEN 0 THEN 0
WHEN 0 THEN 0
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
END AS "Disk Reads/Execution"
END AS "Disk Reads/Execution"
FROM DBA_HIST_SQLSTAT S
FROM DBA_HIST_SQLSTAT S
WHERE SNAP_ID > 209
WHERE SNAP_ID > 209
AND SNAP_ID <= 210
AND SNAP_ID <= 210
AND S.MODULE = 'ClaimCenter'
AND S.MODULE = 'ClaimCenter'
GROUP BY SQL_ID
GROUP BY SQL_ID
HAVING CASE SUM(EXECUTIONS_DELTA)
HAVING CASE SUM(EXECUTIONS_DELTA)
WHEN 0 THEN 0
WHEN 0 THEN 0
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
END >= 0
END >= 0
ORDER BY 2 DESC) DERIVED_TABLE
ORDER BY 2 DESC) DERIVED_TABLE
WHERE ROWNUM <= 100;
WHERE ROWNUM <= 100;
11/13/2022 Oracle性能查询 4