RE: cursor: pin X wait on S

From: Lei Zeng <lzeng_at_yahoo-inc.com>
Date: Mon, 31 Aug 2009 15:35:08 -0700
Message-ID: <EB9DFB3B8215BD428634CD68162F55B60454C783_at_SNV-EXVS06.ds.corp.yahoo.com>

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

Thanks,
Lei Zeng
Sr. Oracle DBA
Yahoo

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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.

Thanks,
Stuart

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 31 2009 - 17:35:08 CDT