My Oracle Support Banner

Database Alert Log Having Frequent Audit Logs with DBMS_SESSION.USE_DEFAULT_EDITION_DEFERRED (Doc ID 2546181.1)

Last updated on JANUARY 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 to 19.3.0.0.0 [Release 18]
Information in this document applies to any platform.

Symptoms

Database Instance alert log is having frequent Audit logs with BEGIN DBMS_SESSION.USE_DEFAULT_EDITION_DEFERRED; END; entries as follows:

BEGIN DBMS_SESSION.USE_DEFAULT_EDITION_DEFERRED; END;
Additional information: hd=0x6d4f3ed8 phd=0x6d4f4630 flg=0x20 cisid=0 sid=0 ciuid=2147483620 uid=<2147483620> sqlid=0qc1hv1q61pu6
...Current username=<SYSRAC>
...Application: oraagent.bin@<HOSTNAME1> (TNS V1-V3) Action:
2019-01-22T15:22:13.909948+01:00
WARNING: too many parse errors, count=57800 SQL hash=0x6c60d746
PARSE ERROR: ospid=43422, error=6550 for statement:
2019-01-22T15:22:13.910086+01:00
BEGIN DBMS_SESSION.USE_DEFAULT_EDITION_DEFERRED; END;
Additional information: hd=0x6d4f3ed8 phd=0x6d4f4630 flg=0x20 cisid=0 sid=0 ciuid=2147483620 uid=<2147483620> sqlid=0qc1hv1q61pu6
...Current username=<SYSRAC>
...Application: oraagent.bin@<HOSTNAME1> (TNS V1-V3) Action:
2019-01-22T15:38:54.556823+01:00
WARNING: too many parse errors, count=57900 SQL hash=0x6c60d746
PARSE ERROR: ospid=43422, error=6550 for statement:
2019-01-22T15:38:54.556970+01:00
BEGIN DBMS_SESSION.USE_DEFAULT_EDITION_DEFERRED; END;
  


Applied the Fix for bug 25562316 and the issue is reoccurred.

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.