cursor: pin X wait on S

• From: Stuart Blackburn <sblackbu@xxxxxxxxx>
• Date: Mon, 31 Aug 2009 18:06:10 -0400

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

• Follow-Ups:
  • RE: cursor: pin X wait on S
    • From: Lei Zeng

• References:
  • How to use RMAN to PIT recover individual tables
    • From: Rich Jesse

Other related posts:

• » cursor: pin X wait on S - Stuart Blackburn
• » RE: cursor: pin X wait on S - Lei Zeng

• » Related posts
• » Previous by Date
• » Next by Date
• » This Month's Archive
• » Main Archive Page
• » View list details
• » Manage your subscription