好久没登录虚拟机了 估计ssd时间久了就卡了
代码如下:
SELECT
t.PARSING_SCHEMA_NAME,
t.SQL_ID AS SQL的ID,
t.SQL_TEXT AS SQL语句,
t.HASH_VALUE AS 完整SQL哈希值,
t.ELAPSED_TIME AS 解析执行总共时间,
t.EXECUTIONS AS 执行总共次数,
t.LAST_ACTIVE_TIME AS 执行最后时间,
t.CPU_TIME AS CPU执行时间微秒
FROM
v$sqlarea t
WHERE
t.PARSING_SCHEMA_NAME IN ( '库名')
order by t.LAST_ACTIVE_TIME desc