简单查看oracle历史会话图表

如图所示 可在plsql中形成线形图 时间范围/节点自己改一下set linesize 300SELECT  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_ALLOCATIONFROM  DBA_HIST_ACTIVE_SESS_HISTORY ashJOIN  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_ALLOCATIONORDER BY  TO_CHAR(TRUNC(ash.sample_time, 'MI'), 'YYYY-MM-DD HH24:MI'),  ash.snap_id,  ash.instance_number;