SELECT A.USERNAME, A.COMMAND, A.STATUS, A.PROGRAM, A.MacHINE, A.CLIENT_IDENTIFIER, B.sql_TEXT, B.CP
SELECT
A.USERNAME, A.COMMAND, A.STATUS,
A.PROGRAM, A.MacHINE, A.CLIENT_IDENTIFIER,
B.sql_TEXT,
B.CPU_TIME,
B.SHARABLE_MEM,
ROUND((B.DISK_READS + B.BUFFER_GETS)/B.EXECUTioNS)
AS RESOURCE_COST
FROM
V$SESSION A,
V$SQLSTATS B
WHERE
A.SQL_ID = B.SQL_ID
AND B.EXECUTIONS >0
AND A.WaiT_CLASS <> 'Idle'
ORDER BY
RESOURCE_COST DESC;
--结束END--
本文标题: oracle 查看实时SQL的CPU使用情况
本文链接: https://www.lsjlt.com/news/44351.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0