My Oracle Support Banner

Duplicated ENTRY_ID For The Same SESSION_ID In UNIFIED_AUDIT_TRAIL (Doc ID 2726651.1)

Last updated on NOVEMBER 24, 2020

Applies to:

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

Symptoms

There are duplicated ENTRY_ID of the audit log rows with the same SESSION_ID in UNIFIED_AUDIT_TRAIL of .

SELECT sessionid,entry_id,dbusername,action_name,UNIFIED_AUDIT_POLICIES FROM unified_audit_trail WHERE dbusername = '<>' ORDER BY event_timestamp DESC ;
SESSIONID ENTRY_ID DBUSERNAME ACTION_NAME UNIFIED_AUDIT_POLICIES
1562875983 8 <> LOGOFF TEST_01
1562875983 8 <> SELECT TEST_02
1562875983 7 <> SELECT TEST_02
1562875983 6 <> SELECT TEST_02
1562875983 5 <> SELECT TEST_02
1562875983 4 <> SELECT TEST_02
1562875983 3 <> SELECT TEST_02
1562875983 2 <> SELECT TEST_02
1562875983 1 <> LOGON TEST_01

Changes

 

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


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