We have ours turned off for a few years now.
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Lok P
Sent: Thursday, January 14, 2021 12:49 PM
To: Oracle L <oracle-l_at_freelists.org>
Subject: Question on tuning Advisor
Wanted to know experts' opinion , if we should turn off automatic tuning advisor jobs. We normally don't see that report or say in other words , we have not got much useful information from automatic tuning advisors jobs reports which can really improve things . Creating new indexes is something that appears most of the time which is not always a feasible option to be implemented. And it does have load in the database while it's running during the specific window(not sure if it actually runs all the sql behind the scene), so is it a good idea to turn this job OFF? We are currently on 11.2.0.4 in this case, so is it better in the recent versions and we should turn it On then?
Regards
Lok
