RE: cursor: pin X wait on S

From: Lei Zeng <>
Date: Mon, 31 Aug 2009 15:35:08 -0700
Message-ID: <>

I have encountered this on one of my RAC node which someone is doing 'select *" from a table with thousands of partitions. This note helped me: 786507.1 HOW TO FIND BLOCKING SESSION FOR MUTEX WAIT EVENT cursor: pin S wait on X

Lei Zeng
Sr. Oracle DBA

-----Original Message-----

[] On Behalf Of Stuart Blackburn Sent: Monday, August 31, 2009 3:06 PM
Cc: Oracle L
Subject: cursor: pin X wait on S

Does anyone know what would cause a lot of "cursor: pin X wait on S" waits in a RAC system? I've read it might be due to a lot of hard parsing, but that doesn't seem to be the case in our system, yet one of our main queries has high concurrency waits due to this.



-- Received on Mon Aug 31 2009 - 17:35:08 CDT

Original text of this message