How to gather ORACLE schema statistics?

Home

To gather the statistic use this command:

execute dbms_stats.gather_schema_stats (ownname =>'PUT_HERE_SCHEMA_NAME',cascade => TRUE);