–// 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.
–// 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.
You must be logged in to post a comment.