SQL Performance (MOSC)

MOSC Banner

Automatic Statistics Job

edited May 23, 2013 6:33AM in SQL Performance (MOSC) 17 commentsAnswered ✓

Hi Gurus,

I am wondering why the statistics are not gathered for any of my tables and indexes though Automatic gathering of CBO statistics is enabled. Please see the details:


1. SQL> select client_name, JOB_SCHEDULER_STATUS from DBA_AUTOTASK_CLIENT_JOB where client_name='auto optimizer stats collection';

no rows selected

2. SQL> SELECT ENABLED FROM DBA_SCHEDULER_PROGRAMS WHERE PROGRAM_NAME = 'GATHER_STATS_PROG';

ENABL
-----
TRUE

3. SQL> SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed FROM dba_autotask_client_history WHERE client_name like '%stats%';

no rows selected

4. SQL> select client_name,status from Dba_Autotask_Client;

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