Hello,
Developer side receive error like:
Code:'50100' Description:'Could not acquire cursor, all cursors are in use. Consider increasing the ODA Cursor Pool Size.' File:'dbstmt.cpp' Line:'269' ,
from database AWR report,
find wait event: cursor: pin S wait on X
then found :
1)hard parse is pretty high.
2) Bug 14380605 - High "library cache lock", "cursor: pin S wait on X" and "library cache: mutex X" waits ( Doc ID 14380605.8 )
Library cache lock and pin usage may be excessive when compiling MERGE SQL statements
so my questions:
1. as to "hard parse is pretty high.", I may do cursor_sharing= force; how do you think?
2. as to "Bug 14380605", any patch?
3. Is this " cursor: pin S wait on X", which caused the problem "'Could not acquire cursor, all cursors are in use. "?
database is : 12.1.0.2, latest CPU already applied .
Thank you very much.