-- 总消耗时间最多的前10条SQL语句
SELECT *
FROM (SELECT V.SQL_ID,
V.CHILD_NUMBER,
V.SQL_TEXT,
V.ELAPSED_TIME,
V.CPU_TIME,
V.DISK_READS,
RANK() OVER(ORDER BY V.ELAPSED_TIME DESC) ELAPSED_RANK
FROM V$SQL V) A
WHERE ELAPSED_RANK <= 10;
-- CPU消耗时间最多的前10条SQL语句
SELECT *
FROM (SELECT V.SQL_ID,
V.CHILD_NUMBER,
V.SQL_TEXT,
V.ELAPSED_TIME,
V.CPU_TIME,
V.DISK_READS,
RANK() OVER(ORDER BY V.CPU_TIME DESC) ELAPSED_RANK
FROM V$SQL V) A
WHERE ELAPSED_RANK <= 10;
-- 消耗磁盘读取最多的前10条SQL语句
SELECT *
FROM (SELECT V.SQL_ID,
V.CHILD_NUMBER,
V.SQL_TEXT,
V.ELAPSED_TIME,
V.CPU_TIME,
V.DISK_READS,
RANK() OVER(ORDER BY V.DISK_READS DESC) ELAPSED_RANK
FROM V$SQL V) A
WHERE ELAPSED_RANK <= 10;
SELECT *
FROM (SELECT V.SQL_ID,
V.CHILD_NUMBER,
V.SQL_TEXT,
V.ELAPSED_TIME,
V.CPU_TIME,
V.DISK_READS,
RANK() OVER(ORDER BY V.ELAPSED_TIME DESC) ELAPSED_RANK
FROM V$SQL V) A
WHERE ELAPSED_RANK <= 10;
-- CPU消耗时间最多的前10条SQL语句
SELECT *
FROM (SELECT V.SQL_ID,
V.CHILD_NUMBER,
V.SQL_TEXT,
V.ELAPSED_TIME,
V.CPU_TIME,
V.DISK_READS,
RANK() OVER(ORDER BY V.CPU_TIME DESC) ELAPSED_RANK
FROM V$SQL V) A
WHERE ELAPSED_RANK <= 10;
-- 消耗磁盘读取最多的前10条SQL语句
SELECT *
FROM (SELECT V.SQL_ID,
V.CHILD_NUMBER,
V.SQL_TEXT,
V.ELAPSED_TIME,
V.CPU_TIME,
V.DISK_READS,
RANK() OVER(ORDER BY V.DISK_READS DESC) ELAPSED_RANK
FROM V$SQL V) A
WHERE ELAPSED_RANK <= 10;