My users are archiving many old datas.
Would it be useful executing this step after archival is complete ?
How do i know if i have to execute EXEC dbms_stats.gather_schema_stats or not?
Can i run this in business hours ?
ANy issue in over writing old statistics.

I am new and with lot of concern on how to proceed.any suggestions will be helpful