Database Tuning (MOSC)

MOSC Banner

auto stat configuration

edited Jun 5, 2013 11:50AM in Database Tuning (MOSC) 13 commentsAnswered
I am having trouble configuring 'auto optimizer stats collection' to work on Oracle 11.2.0.2 on HP-UX. The other two auto tasks are running fine. I have successfully configured this in DEV.

Statistics level is set to TYPICAL and I am logged in as SYS:

SQL> exec dbms_auto_task_admin.enable('auto optimizer stats collection',null,null);

PL/SQL procedure successfully completed.

SQL> select CLIENT_NAME,STATUS from dba_autotask_operation;

CLIENT_NAME                      STATUS
-------------------------------- --------
auto optimizer stats collection  DISABLED
auto space advisor               ENABLED
sql tuning advisor               ENABLED

Querying DBA_AUTOTASK_WINDOW_CLIENTS shows that the stats job is enabled in the desired windows:

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