user12144220 wrote:post the SQL that you would issue manually to accomplish the desired action
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.
user12144220 wrote:Does EM have the ability to reveal the actual PL/SQL & SQL that get executed when you click a button?
After the job executed, all of the recommendations I've implemented are gone. So I run sql tuning advisor and implement recommendations from Enterprise manager. But I need more automated way instead of aforementioned one.
user12144220 wrote:yes, possible; but you have to be smarter than the tools you are (ab)using.
I can change my scheduled getting actual SQLs from EM and putting them into my cron job script. But, instead of that, I hope it can be done on EM when an import job finishes. Is it possible?