Martin Klier


Speaking at Oracle OpenWorld 2012: “Resolving child cursor issues resulting in mutex waits”

On behalf of Klug GmbH integrierte Systeme and the IOUG, I will speak in the US for a second time this year: “Resolving child cursor issues resulting in mutex waits” at Oracle OpenWorld 2012 in San Francisco, Moscone Center.

It’s Session UGF10573 (User Group Forums)
Date and Time: Sunday, 9/30/12, 10:30 – 11:30
Venue / Room: Moscone West – 2016

Speaking at Oracle Open World 2012




In special situations, the Oracle Database generates too many child cursors for particular SQL-IDs. This results in high CPU load on the DB server, coming from heavy mutex access. This is visible as mutex wait events.

The lecture will show how this situation arises, how the DBA can try to quick-fix it and how long-term solutions can be found.

Additionally, we will have a closer look on the Oracle internal situation: Why does the DB use mutexes here, and how?


Martin Klier, Senior DBA
Klug GmbH integrierte Systeme


In general, the lecture is based on the one I presented in Las Vegas at IOUG Collaborate 12 in spring 2012, but now augmented with some new experiences and facts. So it should be interesting for COLLABORATE attendees again.

Oracle: RHEL6 and Oracle Enterprise Linux 6 certified for Database
R.I.P. Oracle Database 10g: “Oracle depends on humidity”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.