My Oracle Support Banner

The reason why a large number of audit trails created when using db-link (Doc ID 2542385.1)

Last updated on APRIL 06, 2020

Applies to:

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

Symptoms

When a db-link table nested loops join as an inner table, If there is an audit policy against to db-link target table, A large number of audit trails will be created like below:

--unified_audit_trail
------------------------------------------------------------------
SQL_TEXT     SQL_BINDS    UNIFIED_AUDIT_POLICIES

---------------------------------------------------------------------------------------------------- ------------ ----------
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):3    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):4    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):3    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):4    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):5    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):6    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):7    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):8    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(1):9    TEST_POL
SELECT /*+ USE_NL (" T2") */ "COL1","COL2 " FROM "TAB2" "T2" W HERE :1="COL1"    #1(2):10    TEST_POL

Changes

 None

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.