Oracle数据库表空间和对象增长查询

Oracle数据库表空间和对象增长查询脚本：

1. Oracle数据库对象增长查询：

点击(此处)折叠或打开

1. select t.snap_id,
   
2.        to_char(t.begin_interval_time, 'yyyy-mm-dd hh24:mi:ss') begin_interval_time,
   
3.        obj.object_id,
   
4.        obj.object_name,
   
5.        round(s.space_used_total /1024/1024,2) object_size
   
6.   from dba_hist_seg_stat s, dba_hist_snapshot t, dba_objects obj, dba_segments c
   
7. where s.snap_id = t.snap_id
   
8.    and s.obj# = obj.object_id
   
9.    and c.segment_name = obj.object_name
   
10.    and c.owner = obj.owner
    
11.    and t.begin_interval_time
    
12.    between to_date('2016-11-10 00:30:00', 'yyyy-mm-dd hh24:mi:ss')
    
13.      and to_date('2016-12-18 18:45:59', 'yyyy-mm-dd hh24:mi:ss')
    
14.      and obj.owner = '&owner'
    
15.      and obj.object_name = '&objectname'
    
16. -- and plan_hash_value in (1101836845, 2899593734)
    
17.    order by s.snap_id

2. Oracle数据库表空间增长查询：

点击(此处)折叠或打开

1. select s.snap_id,
   
2.        ts.name,
   
3.        to_char(snap.begin_interval_time, 'yyyy-mm-dd hh24:mi:ss') begin_interval_time,
   
4.        round(s.tablespace_size/1024/1024,2) tablespace_size
   
5.   from dba_hist_tbspc_space_usage s
   
6.   , v$tablespace ts
   
7.   , dba_hist_snapshot snap
   
8. where s.tablespace_id = ts.ts#
   
9.    and snap.snap_id = s.snap_id
   
10.    and snap.begin_interval_time
    
11.    between to_date('2016-11-10 00:30:00', 'yyyy-mm-dd hh24:mi:ss')
    
12.      and to_date('2016-12-18 18:45:59', 'yyyy-mm-dd hh24:mi:ss')
    
13.      and ts.NAME = '&tbsname'
    
14.    order by s.snap_id

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25105315/viewspace-2129968/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25105315/viewspace-2129968/