My Oracle Support Banner

Instance hang with very high wait on 'cursor: mutex S' (Doc ID 1274320.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


2 node RAC, intermittently instance is slow then go into 'hang' status without accepting any new connections. There is very high wait of 'cursor: mutex S'.

AWR report during slow/hanging period shows:

Top 5 Timed Foreground Events

Event                     Waits     Time(s) Avg wait (ms) % DB time    Wait Class
cursor: mutex S   5,895,761   19,387            3       32.29     Concurrency
DB CPU                  16,926                                    28.19
library cache lock 122,326      9,803            80     16.33 Concurrency
db file sequential read 524,864  1,332          3       2.22     User I/O
enq: TX - row lock contention  7     380   54317      0.63 Application


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.