12_Analyze_Object.sql

12_Analyze_Object.sql

select 'analyze '||segment_type||' '||owner||'.'||segment_name||' compute statistics;'

from   dba_segments

where  owner        = upper('&owner')

and    segment_type = upper('&segment_type')

group  by segment_type,owner,segment_name

order  by sum(bytes)

/