High Concurrency Wait
From: Sanjay Mishra <"Sanjay>
Date: Tue, 28 Nov 2017 20:09:28 +0000 (UTC)
Message-ID: <967047002.3448607.1511899768338_at_mail.yahoo.com>
Date: Tue, 28 Nov 2017 20:09:28 +0000 (UTC)
Message-ID: <967047002.3448607.1511899768338_at_mail.yahoo.com>
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
TIASanjay
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 28 2017 - 21:09:28 CET