Verificar as recomendacoes do SEGMENT ADVISOR sem entrar no EM

Com a consulta abaixo conseguimos ter acesso as recomendacoes do Segment advisor.

SELECT 
                   'Segment Advice --------------------------'|| chr(10) || 
                   'TABLESPACE_NAME           : ' || tablespace_name              || chr(10) || 
                   'SEGMENT_OWNER             : ' || segment_owner                || chr(10) || 
                   'SEGMENT_NAME              : ' || segment_name                 || chr(10) || 
                   'ALLOCATED_SPACE           : ' || allocated_space              || chr(10) || 
                   'RECLAIMABLE_SPACE: ' || reclaimable_space || chr(10) || 
                   'RECOMMENDATIONS           : ' || recommendations              || chr(10) || 
                   'SOLUTION 1                : ' || c1                           || chr(10) || 
                   'SOLUTION 2                : ' || c2                           || chr(10) || 
                   'SOLUTION 3                : ' || c3 Advice
FROM
                   TABLE(dbms_space.asa_recommendations('FALSE', 'FALSE', 'FALSE')); 


Comentários