Re: High Concurrency Wait

From: Sayan Malakshinov <>
Date: Wed, 29 Nov 2017 01:47:37 +0300
Message-ID: <>


And finally it's the time for Tanel's latchprofx :)

On Tue, Nov 28, 2017 at 11:09 PM, Sanjay Mishra <
> wrote:

> Hi
> Can someone guide as what need to be looked for High wait on "cursor: pin
> S wait on X' happening in on Exadata. I checked with Tanel Ashtop
> and this events comes at more than 75% and even snapper also show the same
> with top event for the same. Running snapper every 5 second are showing
> different SQLID for the event.
> Any link or guidance to check as this been reported only in last few days
> and I checked with dashtop (Tanel Script) and same even is on top in all
> last available 7 days of the ASH history
> Sanjay

Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate

Received on Tue Nov 28 2017 - 23:47:37 CET

Original text of this message