oracle历史会话查看

汪灵骅

于 2024-07-26 10:52:08 发布

阅读量35

点赞数 1

分类专栏： oracle 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/u014596132/article/details/140709739

版权

oracle 专栏收录该内容

121 篇文章 1 订阅

订阅专栏

时间范围/节点自己改一下

set linesize 300
SELECT
  TO_CHAR(TRUNC(ash.sample_time, 'MI'), 'YYYY-MM-DD HH24:MI') AS minute_interval,
  ash.snap_id,
  ash.instance_number AS inst_id,
  COUNT(DISTINCT ash.session_id) AS active_sessions,
  res.resource_name,
  res.current_utilization,
  res.max_utilization,
  res.INITIAL_ALLOCATION
FROM
  DBA_HIST_ACTIVE_SESS_HISTORY ash
JOIN
  DBA_HIST_RESOURCE_LIMIT res ON ash.snap_id = res.snap_id AND ash.instance_number = res.instance_number
  where ash.sample_time>to_date('2024-04-12 11:00:00','yyyy-MM-dd HH24:mi:ss') and ash.sample_time<to_date('2024-04-13 00:15:00','yyyy-MM-dd HH24:mi:ss') and ash.INSTANCE_NUMBER=2
  and res.resource_name in ('processes','sessions')
GROUP BY
  TO_CHAR(TRUNC(ash.sample_time, 'MI'), 'YYYY-MM-DD HH24:MI'),
  ash.snap_id,
  ash.instance_number,
  res.resource_name,
  res.current_utilization,
  res.max_utilization,
  res.INITIAL_ALLOCATION
ORDER BY
  TO_CHAR(TRUNC(ash.sample_time, 'MI'), 'YYYY-MM-DD HH24:MI'),
  ash.snap_id,
  ash.instance_number;