DEFAULT_MAINTENANCE_PLAN
Just wanted to ask you that in one of the database server's alert log file i am getting
"Wed Mar 27 10:30:00 2013
Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Wed Mar 27 10:30:02 2013
Wed Mar 27 10:30:02 2013
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 2496507518 "
so what this stuff indicating...
what is default_maintenance_plan ? i mean what are the activities done through default_maintenance_plan...??
And what is performance impact of default_maitenance_plan on system specially ?
when i have queried dba_scheduler_windows of that database i found that its repeat_interval is like "freq=daily;byday=MON;byhour=22;byminute=0; bysecond=0" but next_start_date is like