Database Hangs With The Wait Event 'enq: MC - Securefile log' When Unified Auditing Is Enabled (Doc ID 2276241.1)

Last updated on JUNE 27, 2017

Applies to:

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

Symptoms

After enabling one or more Unified Auditing policies the 'enq: MC - Securefile log' wait event will be seen whenever the users will execute actions that are audited. If there will be many audited actions executed simultaneously at the database level or a purge operations is executed during peak hours, the users can experience database wide hangs whose hanganalyze traces will look similar to this :

 

Final Blocker: inst: 1, sid: 536, ser: 22606
249: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: 22606
250: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: 22606
251: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: 22606
252: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: 22606
253: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Cmd: Select
Final Blocker: inst: 1, sid: 536, ser: 22606
254: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: 22606
255: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: 22606
256: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Cmd: Select

 

 

Cause

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