Auto Gather Stats not Running
Hi All,
We are fairly new to 11g and have a learning curve with its features.
One of the features that we really liked about it is the automation of stats gathering, but we have noticed that the last analyzed date of our heavy usage table is already stale.
Our table was last analyzed at 10-FEB-15, and most of the other tables are at 28-FEB-15.
Im beginning to think that the auto stats gather job is either failing or isn't being triggered.
Please also excuse my query format as im not used to formatting.
SQL> SELECT client_name, status FROM dba_autotask_operation;