Database Alert Log Having Frequent Audit Logs with DBMS_SESSION.USE_DEFAULT_EDITION_DEFERRED
(Doc ID 2546181.1)
Last updated on APRIL 17, 2023
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;
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 |