Oracle Database Discussions

Hi All,

DB -- 11.1.0.6.0.

We have auto stats gathering is enabled , but somehow , it's not running. not sure , what is causing this ? Oracle support recommended following steps , but my manager is not comfortable with this. strange thing, they were running fine prior to 4th of Feb. since then , they stopped running automatically and no one changed anything here. would really appreciate , if someone could able to offer something meaningful here.

It seems DBA_SCHEDULER_GROUP_MEMBERS view does not exist.

Could you please run below commands ?

$sqlplus "/as sysdba"

SQL> startup upgrade

SQL > spool catalog.log
SQL > @?/rdbms/admin/catalog.sql
SQL > spool off;

SQL > spool catproc.log
SQL > @?/rdbms/admin/catproc.sql
SQL > spool off;

SQL > @?/rdbms/admin/utlrp.sql
SQL > @?/rdbms/admin/utlrp.sql


select * from dba_objects where object_name ='DBA_SCHEDULER_GROUP_MEMBERS';


WINDOW_NAME                    REPEAT_INTERVAL                DURATION                       ENABLED
------------------------------ ------------------------------ ------------------------------ --------------------
MONDAY_WINDOW                  freq=daily;byday=MON;byhour=22 +000 04:00:00                  TRUE
                               ;byminute=0; bysecond=0

TUESDAY_WINDOW                 freq=daily;byday=TUE;byhour=22 +000 04:00:00                  TRUE
                               ;byminute=0; bysecond=0

WEDNESDAY_WINDOW               freq=daily;byday=WED;byhour=22 +000 04:00:00                  TRUE
                               ;byminute=0; bysecond=0

THURSDAY_WINDOW                freq=daily;byday=THU;byhour=22 +000 04:00:00                  TRUE
                               ;byminute=0; bysecond=0

FRIDAY_WINDOW                  freq=daily;byday=FRI;byhour=22 +000 04:00:00                  TRUE
                               ;byminute=0; bysecond=0

SATURDAY_WINDOW                freq=daily;byday=SAT;byhour=6; +000 20:00:00                  TRUE
                               byminute=0; bysecond=0

SUNDAY_WINDOW                  freq=daily;byday=SUN;byhour=6; +000 20:00:00                  TRUE
                               byminute=0; bysecond=0

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

SQL> select window_name,active from DBA_SCHEDULER_WINDOWS;

WINDOW_NAME                    ACTIV
------------------------------ -----
MONDAY_WINDOW                  FALSE
TUESDAY_WINDOW                 FALSE
WEDNESDAY_WINDOW               FALSE
THURSDAY_WINDOW                TRUE
FRIDAY_WINDOW                  FALSE
SATURDAY_WINDOW                FALSE
SUNDAY_WINDOW                  FALSE
WEEKNIGHT_WINDOW               FALSE
WEEKEND_WINDOW                 FALSE