Database Administration (MOSC)

MOSC Banner

Stats job not running on defined days

edited Apr 17, 2011 7:01PM in Database Administration (MOSC) 3 commentsAnswered ✓
 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',

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