Re: High Concurrency Wait

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 29 Nov 2017 01:47:37 +0300
Message-ID: <CAOVevU40qB72m8W9HHkasEJt4JisvHDrG78JEMoabQG9Sp-SBw_at_mail.gmail.com>



Hi,

And finally it's the time for Tanel's latchprofx :) http://blog.tanelpoder.com/files/Oracle_Latch_And_Mutex_Contention_Troubleshooting.pdf

On Tue, Nov 28, 2017 at 11:09 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org
> wrote:

> Hi
>
> Can someone guide as what need to be looked for High wait on "cursor: pin
> S wait on X' happening in 12.1.0.2 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
>
> TIA
> Sanjay
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 28 2017 - 23:47:37 CET

Original text of this message