Re: Question on tuning Advisor

Thank you all!!

On Fri, Jan 15, 2021 at 4:02 PM Pap <oracle.developer35_at_gmail.com> wrote:

> Below docs does state it executes the sql partially, which means the
> tuning advisor really executes the underlying sql and that is why mostly
> the additional load came into picture while it's running and thus people
> kept it as turned off.
>
> https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL569
>
> On Fri, Jan 15, 2021 at 12:06 AM Lok P <loknath.73_at_gmail.com> wrote:
>
>> Thanks Much for the confirmation.
>>
>> Does it actually run/trigger the exact application sql queries behind the
>> scene by itself? or just get the information from awr/ash stats only
>> without actually running any sql?
>>
>> Regards
>> Lok
>>
>> On Thu, Jan 14, 2021 at 11:27 PM Noveljic Nenad <
>> nenad.noveljic_at_vontobel.com> wrote:
>>
>>> We’ve turned the following advisors off on all of our databases: sql
>>> tuning, segment space and statistics advisors, because they were causing
>>> significant load on the system without providing any useful information.
>>> We’ve never looked back.
>>>
>>>
>>>
>>> Disclaimer: I’m not an expert, just a longtime practitioner.
>>>
>>>
>>>
>>> Best regards,
>>>
>>>
>>>
>>> Nenad
>>>
>>>
>>>
>>> http://nenadnoveljic.com/blog/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>>> Behalf Of *Lok P
>>> *Sent:* Donnerstag, 14. Januar 2021 18:49
>>> *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
>>>
>>> ____________________________________________________
>>>
>>> Please consider the environment before printing this e-mail.
>>>
>>> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>>>
>>>
>>> Important Notice
>>> This message is intended only for the individual named. It may contain
>>> confidential or privileged information. If you are not the named addressee
>>> you should in particular not disseminate, distribute, modify or copy this
>>> e-mail. Please notify the sender immediately by e-mail, if you have
>>> received this message by mistake and delete it from your system.
>>> Without prejudice to any contractual agreements between you and us which
>>> shall prevail in any case, we take it as your authorization to correspond
>>> with you by e-mail if you send us messages by e-mail. However, we reserve
>>> the right not to execute orders and instructions transmitted by e-mail at
>>> any time and without further explanation.
>>> E-mail transmission may not be secure or error-free as information could
>>> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
>>> processing of incoming e-mails cannot be guaranteed. All liability of
>>> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
>>> referred to as "Vontobel Group") for any damages resulting from e-mail use
>>> is excluded. You are advised that urgent and time sensitive messages should
>>> not be sent by e-mail and if verification is required please request a
>>> printed version. Please note that all e-mail communications to and from the
>>> Vontobel Group are subject to electronic storage and review by Vontobel
>>> Group. Unless stated to the contrary and without prejudice to any
>>> contractual agreements between you and Vontobel Group which shall prevail
>>> in any case, e-mail-communication is for informational purposes only and is
>>> not intended as an offer or solicitation for the purchase or sale of any
>>> financial instrument or as an official confirmation of any transaction.
>>> The legal basis for the processing of your personal data is the
>>> legitimate interest to develop a commercial relationship with you, as well
>>> as your consent to forward you commercial communications. You can exercise,
>>> at any time and under the terms established under current regulation, your
>>> rights. If you prefer not to receive any further communications, please
>>> contact your client relationship manager if you are a client of Vontobel
>>> Group or notify the sender. Please note for an exact reference to the
>>> affected group entity the corporate e-mail signature. For further
>>> information about data privacy at Vontobel Group please consult
>>> www.vontobel.com.
>>>
>>

--
http://www.freelists.org/webpage/oracle-l