Database Administration (MOSC)

MOSC Banner

enabled auto statistics collection on dev/qa/pilot/prod environment. However none of them function r

edited Mar 28, 2013 3:09AM in Database Administration (MOSC) 7 commentsAnswered
I have enabled auto statistics collection on dev/qa/pilot/prod environment. However none of them function right.

For example:

the next_start_date is behind after couple days good run:
MAINTENANCE_WINDOW_GROUP       TRUE                  7 22-MAR-13 10.00.00.000000 PM UTC                                Window group for Automated Maintenance
ORA$AT_WGRP_OS                 TRUE                  7 22-MAR-13 10.00.00.000000 PM UTC                                auto optimizer stats collection
ORA$AT_WGRP_SA                 TRUE                  7 22-MAR-13 10.00.00.000000 PM UTC                                auto space advisor
ORA$AT_WGRP_SQ                 TRUE                  7 22-MAR-13 10.00.00.000000 PM UTC                                sql tuning advisor

And then I would restart the scheduler thing by running following:
SQL> @?/rdbms/admin/catnomwn.sql
SQL> @?/rdbms/admin/catmwin.sql
SQL> @?/rdbms/admin/utlrp.sql

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