SQL Performance (MOSC)

MOSC Banner

Auto Gather Stats not Running

edited Jun 1, 2015 1:40AM in SQL Performance (MOSC) 11 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center