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

Now would be a good time to provide some details:

• Operating System & relevant details (version, memory)?
• Oracle Version, Edition, Patch level?
• Some load information (Users/Threads/Connection, Connection style) ?

On 2017-10-03 9:47 AM, Ravi Teja Bellamkonda wrote:
> Hi,
>
> I started my analysis based on the AWR Report, which is stating high
> wait events on Latch Free.
>
> Inline image 1
>
> On Tue, Oct 3, 2017 at 8:08 AM, bhavani d <bhavani021_at_gmail.com
> <mailto: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
> <mailto: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 <mailto: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