Pular para o conteúdo

Fóruns Banco de dados Oracle Tablespace System extendendo muito Tablespace System extendendo muito

#102157
Douglas Paiva de Sousa
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;