High Waits for 'library cache lock' and 'library cache: mutex X' Due to Parse Failures When Using JDBC ResultSet.TYPE_SCROLL_SENSITIVE (Doc ID 1566018.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

• You are using JDBC in the application and the "ResultSet.TYPE_SCROLL_SENSITIVE" feature that permits scrolling of the result set returned from the database.

Other symptoms may vary, but may include:

• high "library cache lock" and "library cache: mutex X" waits
  
  
  
  
  
• Disproportionately high "failed parse elapsed time" under the "Time Model Statistics" section of AWR:
  
  
  
  
  
• A high number or "parse count (failures)" under "Instance Activity Stats"
  
  
  .
  .
  

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.