High Waits on 'library cache: mutex X' Inserting into a Partitioned Table when DEFERRED_SEGMENT_CREATION = TRUE
Last updated on JULY 07, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms