High Waits on 'library cache: mutex X' Inserting into a Partitioned Table when DEFERRED_SEGMENT_CREATION = TRUE
(Doc ID 1590806.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- The wait event 'library cache: mutex X' appears in the Top Five Timed Foreground Events of the AWR (or Statspack) report.
- Top SQL with Top Events Section of the ASH report shows the event 'library cache: mutex X' is related to an INSERT statement into an interval partitioned table.
(It's possible that other events are also associated with the same INSERT statement.)
There may be no apparent changes, or you may have recently upgraded from a release of Oracle Database at 10g or below.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!