Oracle – Analisar Objetos Fragmentados no Banco de Dados (Performance)

Oracle

–// Analisar Objetos Fragmentados no Banco de Dados (Performance)

SELECT SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES / 1024 / 1024 TAM, EXTENTS

FROM DBA_SEGMENTS

WHERE EXTENTS > 100 ORDER BY EXTENTS

Abraços.

No Comments

Leave a Reply

You must be logged in to post a comment.