Re: High Concurrency Wait

From: Mladen Gogala <>
Date: Tue, 28 Nov 2017 19:59:20 -0500
Message-ID: <>

Also, do you have CURSOR_SHARING=FORCE? If so, your pin problems may be a result of the parsing storm.

On 11/28/2017 03:09 PM, Sanjay Mishra (Redacted sender smishra_97 for DMARC) 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

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Wed Nov 29 2017 - 01:59:20 CET

Original text of this message