Which table is using maximum tablespace :-
Run the below SQL :-
select sum(bytes)/1024/1024, s.segment_name, s.segment_type
from dba_lobs l, dba_segments s
where s.segment_type = 'LOBSEGMENT'
and l.table_name = 'PS_PV_ATT_DB_SRV'
and s.segment_name = l.segment_name
group by s.segment_name,s.segment_type;
Run the below SQL :-
select sum(bytes)/1024/1024, s.segment_name, s.segment_type
from dba_lobs l, dba_segments s
where s.segment_type = 'LOBSEGMENT'
and l.table_name = 'PS_PV_ATT_DB_SRV'
and s.segment_name = l.segment_name
group by s.segment_name,s.segment_type;
No comments:
Post a Comment