This discussion is archived
5 Replies Latest reply: Nov 18, 2012 7:34 AM by user12144220 RSS

How do I execute sql tuning advisor automatically after import job?

user12144220 Newbie
Currently Being Moderated
Hello everyone,

I have a question regarding SQL tuning set. I want to have a scheduled task which creates SQL tuning sets and implements recommendations automatically on Enterprise manager as soon as import job finished via datapump along cron scheduled task if possible?

Oracle database version: 11gR2
Operating system: OEL 5

Any kind of suggestion would be appreciated.

Thank you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points