Automatic Maintenance Tasks
Hi,
I am using 11.1.0.7 on Solaris 10 on SPARC.
I am requesting if someone can brief me about auto maintenence tasks in oracle 11.1. I know the maintenance windows for week days have a time from 10:00 PM to 2:00 AM midnight. Then for week ends(Saturdays, Sundays), it is from 6:00 AM to next day 2:00 AM (20 hours). I also understand that 3 tasks are done during these windows 1) oprimizer stats gathering, 2) segment advisor, 3) SQL tuning advisor.
I am using 11.1.0.7 on Solaris 10 on SPARC.
I am requesting if someone can brief me about auto maintenence tasks in oracle 11.1. I know the maintenance windows for week days have a time from 10:00 PM to 2:00 AM midnight. Then for week ends(Saturdays, Sundays), it is from 6:00 AM to next day 2:00 AM (20 hours). I also understand that 3 tasks are done during these windows 1) oprimizer stats gathering, 2) segment advisor, 3) SQL tuning advisor.
All auto tasks will run every 4 hours on week end window excep "Automatic SQL Tuning Advisor ", Can anyone guide me how can I change my optimizer statis task also to be set to run once only, not every 4 hours during week-end window?
2