cursor: pin X wait on S

From: Stuart Blackburn <sblackbu_at_cbnco.com>
Date: Mon, 31 Aug 2009 18:06:10 -0400
Message-ID: <4A9C4952.80600_at_cbnco.com>



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
Received on Mon Aug 31 2009 - 17:06:10 CDT

Original text of this message