Turn it off and execute it manually if you really need it.
---
Thanks,
Shane Borden
sborden76@xxxxxxxxx
On Jan 14, 2021, at 12:58 PM, Beckstrom, Jeffrey <jbeckstrom@xxxxxxxxx> wrote:
We have ours turned off for a few years now.
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>> On
Behalf Of Lok P
Sent: Thursday, January 14, 2021 12:49 PM
To: Oracle L <oracle-l@xxxxxxxxxxxxx <mailto: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