SELECT segment_owner, segment_name, segment_type, recommendations
FROM TABLE (DBMS_SPACE.asa_recommendations ('FALSE', 'FALSE', 'FALSE'))
WHERE segment_type in ('TABLE', 'INDEX')
And recommendations like '%shrink%';

HOME