Question on tuning Advisor
From: Lok P <loknath.73_at_gmail.com>
Date: Thu, 14 Jan 2021 23:19:25 +0530
Message-ID: <CAKna9VZjpQ+8hmkENgEc8NKtCjuwxTjs_C1phkthXJZit4HCkA_at_mail.gmail.com>
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?
Date: Thu, 14 Jan 2021 23:19:25 +0530
Message-ID: <CAKna9VZjpQ+8hmkENgEc8NKtCjuwxTjs_C1phkthXJZit4HCkA_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 14 2021 - 18:49:25 CET