We have ours turned off for a few years now.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Lok P
Sent: Thursday, January 14, 2021 12:49 PM
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
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