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；
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2025-7-5 16:50:26
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对