› Fóruns › Banco de dados Oracle › Tablespace System extendendo muito › Tablespace System extendendo muito
14 de dezembro de 2011 às 8:53 pm
#102157
Participante
Execute a query abaixo e verifique as primas linhas.
select segment_name, owner, round(sum(bytes)/1024/1024,2) as “Size”
from dba_segments
where tablespace_name = ‘SYSTEM’
and owner not in (‘SYS’,’SYSTEM’,’DBSNMP’,’SYSMAN’)
group by segment_name, owner
order by 3 desc;