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