Oracle数据库表空间和对象增长查询脚本：
1. Oracle数据库对象增长查询：
点击(此处)折叠或打开
-
select t.snap_id,
-
to_char(t.begin_interval_time, 'yyyy-mm-dd hh24:mi:ss') begin_interval_time,
-
obj.object_id,
-
obj.object_name,
-
round(s.space_used_total /1024/1024,2) object_size
-
from dba_hist_seg_stat s, dba_hist_snapshot t, dba_objects obj, dba_segments c
-
where s.snap_id = t.snap_id
-
and s.obj# = obj.object_id
-
and c.segment_name = obj.object_name
-
and c.owner = obj.owner
-
and t.begin_interval_time
-
between to_date('2016-11-10 00:30:00', 'yyyy-mm-dd hh24:mi:ss')
-
and to_date('2016-12-18 18:45:59', 'yyyy-mm-dd hh24:mi:ss')
-
and obj.owner = '&owner'
-
and obj.object_name = '&objectname'
-
-- and plan_hash_value in (1101836845, 2899593734)
- order by s.snap_id
2. Oracle数据库表空间增长查询：
点击(此处)折叠或打开
-
select s.snap_id,
-
ts.name,
-
to_char(snap.begin_interval_time, 'yyyy-mm-dd hh24:mi:ss') begin_interval_time,
-
round(s.tablespace_size/1024/1024,2) tablespace_size
-
from dba_hist_tbspc_space_usage s
-
, v$tablespace ts
-
, dba_hist_snapshot snap
-
where s.tablespace_id = ts.ts#
-
and snap.snap_id = s.snap_id
-
and snap.begin_interval_time
-
between to_date('2016-11-10 00:30:00', 'yyyy-mm-dd hh24:mi:ss')
-
and to_date('2016-12-18 18:45:59', 'yyyy-mm-dd hh24:mi:ss')
-
and ts.NAME = '&tbsname'
- order by s.snap_id
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25105315/viewspace-2129968/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Redis 保护模式
下一篇：
MYSQL字符集设置
请登录后发表评论
登录
全部评论
