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
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.