Skip to content

segment grown trend

segment grown trend published on Комментариев к записи segment grown trend нет
column owner format a10
column object_name format a30
column "tablespace name" format a15
select s.s_id ,s.e_id,o.owner , o.object_name , o.subobject_name , o.object_type , 
t.name "tablespace name", s.growth/(1024*1024) "growth in mb", 
(select sum(bytes)/(1024*1024) 
   from dba_segments 
   where segment_name=o.object_name
) "total size(mb)" 
from dba_objects o 
    join 
    (select min(ss.begin_interval_time) as s_id,max(ss.begin_interval_time) as e_id,ts#,obj#, sum(space_used_delta) growth 
      from dba_hist_seg_stat st 
        join dba_hist_snapshot ss on st.snap_id=ss.snap_id
      group by ts#,obj# 
      having sum(space_used_delta) > 0 
      order by 2 desc
    ) s on s.obj#=o.object_id 
    join v$tablespace t on s.ts#=t.ts# 
where rownum < 11 
order by 8 desc;

found at community.oracle.com

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

Primary Sidebar

Яндекс.Метрика