ALTERNATING ANALYZE QUERIES FOR PERFORMANCE ENHANCEMENT :



>> EXEC DBMS_UTILITY.analyze_schema('SCHEMA_NAME,'COMPUTE');

>> exec DBMS_UTILITY.ANALYZE_SCHEMA('SCHEMA_NAME','COMPUTE');

>>EXEC DBMS_UTILITY.ANALYZE_SCHEMA('SCHEMA_NAME','ESTIMATE', estimate_rows => 1000);

>> exec DBMS_UTILITY.ANALYZE_SCHEMA('SCHEMA_NAME','ESTIMATE', estimate_percent => 25);

>> exec dbms_utility.analyze_schema(‘SCHEMA_NAME’,'ESTIMATE’, NULL, 50, ‘FOR ALL INDEXES’);

>> exec dbms_utility.analyze_schema(‘SCOTT’,'ESTIMATE’, NULL, 50, ‘FOR TABLE’);