Re: Cusror: Pin S wait in X

From: Stefan Knecht <>
Date: Tue, 19 Dec 2017 13:39:12 +0700
Message-ID: <>

More details are needed to give you any kind of specific answer:

  • What Oracle version exactly?
  • What are these sessions running? (Query + Plan)
  • Does the query run in parallel?
  • Does the query use bind variables?
  • You can also look in x$mutex_sleep to see the most active mutexes (it's likely Cursor Pin but might be something else on the off chance). Snap it a few times and compare to see what's actively being used right now.


zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at | Support our Indiegogo campaign at |

On Tue, Dec 19, 2017 at 4:59 AM, Sanjay Mishra <>

> Can some one suggest what can be done to stop these wait as it coming as
> topmost event for multiple SID ? I tried to following 786507.1 doc to
> identify the session but if I kill one session another one comes up. I even
> bounced the Instance one by one but this still continues. Any suggestion as
> else had to open Oracle ticket due to slowness been reported. Ashtop shows
> all top 20 listed process with same Waiteven and with one same SQL id
> Sanjay
Received on Tue Dec 19 2017 - 07:39:12 CET

Original text of this message