Database Hangs With The Wait Event 'enq: MC - Securefile log' When Unified Auditing Is Enabled
(Doc ID 2276241.1)
Last updated on FEBRUARY 23, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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: XXXXX
249: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
250: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
251: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
252: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
253: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Cmd: Select
Final Blocker: inst: 1, sid: 536, ser: XXXXX
254: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
255: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
256: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Cmd: Select
249: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
250: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
251: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
252: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
253: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Cmd: Select
Final Blocker: inst: 1, sid: 536, ser: XXXXX
254: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
255: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Final Blocker: inst: 1, sid: 536, ser: XXXXX
256: waiting for 'enq: MC - Securefile log'[Enq MC-00000000-87EFB967-00000000-00000000]
Cmd: Select
Changes
Unified Auditing has been enabled in the database.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |