Collecting Statistics for System Component Schemas :

The best way to enhance the performance of

running processes is to gather statistics on a schema. The following command is best collectively gather statistics for a schema.

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA_NAME',DBMS_STATS.AUTO_SAMPLE_SIZE);