Three different methods[edit]
Plain analyze command[edit]
analyze table table_name compute statistics;
Schema level analyze using DBMS_UTILITY.ANALYZE_SCHEMA[edit]
execute DBMS_UTILITY.ANALYZE_SCHEMA('EMPI', 'ESTIMATE')
Schema level analyze using DBMS_STAT[edit]
