Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

change automatic SQL Tuning Advisor time

984624May 8 2013 — edited May 12 2013

Hi All,

can anyone help me in changing "automatic SQL Tuning Advisor" job timingsm because currently it is scheduled during peak hours , i want to change it to evening 6 pm daily.Because during peak hours it is taking more cpu and taking one hour.

Wed May 08 08:00:10 2013
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Wed May 08 08:05:47 2013

thanks

Mapps

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2013

Added on May 8 2013

#general-database-discussions

12 comments

1,510 views