Stats job not running on defined days
Hi,
The stats job "GATHER_STATS_JOB" was running daily from MON-FRI and we were having performance issues whenever the stats job was running during the RMAN fullbackup.To avoid performance issues,we modified the stats job DEFINITION to run the job only on MON,TUE,THUR and FRI (not on WED and WEEK ENDS). After the modification, we notice that the stats job is running only on MON and there is no execution on other days. The stats job DEFINITION is modified by running the below commands:
STEPS:
1)connect as sysdba
1)
BEGIN
DBMS_SCHEDULER.drop_window (
window_name => 'MAINT_WINDOW_GROUP',
STEPS:
1)connect as sysdba
1)
BEGIN
DBMS_SCHEDULER.drop_window (
window_name => 'MAINT_WINDOW_GROUP',
0