oracle如何查询历史最大进程数？ - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

5172468635d9b2c5cd.png (8.62 KB, 下载次数: 315)

2025-7-1 12:01 上传

set line 300
col resource_name for a15
select res.instance_number,to_char(snap.end_interval_time, 'yyyy-mm-dd hh24:mi:ss') snap_time,
   resource_name,
   current_utilization,max_utilization,
   res.limit_value
  from dba_hist_resource_limit res, dba_hist_snapshot snap
where res.snap_id = snap.snap_id
and res.instance_number=snap.instance_number
and resource_name in ('processes', 'sessions')
  order by 3,2 desc；

输出结果：