Re: Lot of Latch Free and Enqueue Hash Chain Wait Events

Hi,

I started my analysis based on the AWR Report, which is stating high wait events on Latch Free.

[image: Inline image 1]

On Tue, Oct 3, 2017 at 8:08 AM, bhavani d <bhavani021_at_gmail.com> wrote:

> Dont assume.
>
> Just take the AWR report and verify in top wait event section
>
> On Tue, Oct 3, 2017 at 10:59 AM, Ravi Teja Bellamkonda <
> raviteja.bellamkonda7_at_gmail.com> wrote:
>
>> Hi,
>>
>> Thanks for your time.
>>
>> Some slowness was reported on the database calls, but that could be
>> because of the load on the database.
>>
>> I am assuming that there might be a problem based on the observations.
>>
>> Thanks.
>>
>>
>> On Oct 3, 2017 7:55 AM, "Hans Forbrich" <fuzzy.graybeard_at_gmail.com>
>> wrote:
>>
>> Are you actually experiencing a problem? Or are you assuming there is a
>> problem because of your observations?
>>
>> /Hans
>>
>>
>> On 2017-10-03 8:38 AM, Ravi Teja Bellamkonda wrote:
>>
>> Hi List,
>>
>> First of all, thank you for all the time and support.
>>
>> Problem Statement is that under load we are observing a lot of Latch Free
>> wait events which are followed by Enqueue Hash Chains.
>> ...
>>
>> --
>> Thanks & Regards,
>> Ravi Teja Bellamkonda
>>
>>
>>
>>
>
>
> --
> Thanks,
> Bhavani Prasad.
>

-- 
Thanks & Regards,
Ravi Teja Bellamkonda
Ph: (816)-905-7577.





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




image/png attachment: image.png