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

Is this Standard Edition 2 ? You may be throttled by the database on purpose.

It would help if you give version details when asking a question here.

On Tue, Oct 3, 2017 at 9:38 PM, Ravi Teja Bellamkonda < raviteja.bellamkonda7_at_gmail.com> 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.
>
> [image: Inline image 2]
>
> Digging a bit more I was able to find the latch.
>
> [image: Inline image 1]
>
> I cannot make any conclusions based on this. Please provide any
> recommendations on solving this issue or conclusions for this event.
> --
> Thanks & Regards,
> Ravi Teja Bellamkonda
>
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
_at_zztat_oracle









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




image/png attachment: image.png



image/png attachment: image.png