orcle2 查询执行计划

好久没登录虚拟机了   估计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