Hello Gurus,
Version : 11.2.0.4
In our production environment from past 20 days we have been added 500GB of space to one of table space - Don't know exactly which segment (hot) is occupying - Is there way to determine which segment is eating is our space in table-space?
I tried with the below query. but cannot able to figure it out which is actual segment is consuming the space. Please help me.
select segment_name,segment_type,OWNER,sum(bytes)/1024/1024/1024 from dba_segments where tablespace_name=<TABLESPACE_NAME>
AND SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION',
'INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'TEMPORARY', 'LOBINDEX', 'LOBSEGMENT', 'LOB PARTITION')
group by segment_name,segment_type,OWNER order by sum(bytes)/1024/1024/1024 desc