vConf 2021: Troubleshooting Very Complex Oracle Performance...
Occasionally, Oracle decided to not reuse existing child cursors for some queries in a busy OLTP system, causing new child cursors to be parsed and loaded into the library cache. This caused exclusive mutex hold