QUESTIONS Does my database gather statistics automatically? If not what should I do?   RELATED RESCHEDULING OF THE AUTOMATIC OPTIMIZER STATISTICS COLLECTION JOB   SOLUTION First of all, identify if Automatic Optimizer Statistics Collection Job (AOSCJ) runs on regular basis. It can be done…

  REQUEST I want the Automatic Optimizer Statistics Collection Job (AOSCJ) executes with another time schedule.   RELATED ENSURING THAT MY DATABASE GATHERS STATISTICS ON A DAILY BASIS   SOLUTION Find out the status of AOSCJ SET LINES 300 SET PAGES 999 COL CLIENT_NAME FOR…