User PUBLIC is detected Username Detected In Active Session on Standby database
Information in this document applies to any platform.
SYMPTOMS
Connections for user PUBLIC were detected on a Standby database for some time.
INST_ID SQL_HASH_VALUE MACHINE USERNAME OSUSER SID PROCESS SERIAL# STATUS SERVER TO_CHAR(LOGON_TIME,'DD-MON-YYY
---------- ---------------------- ------------------- --------------- ----------- --------- ------------ ---------- ---------- -------------- -------------------------------------------
1 0 <machine name> PUBLIC oracle 2910 168531 36113 INACTIVE DEDICATED 22-mar-2020, 02:48:26
Is this an Expected Behavior
CAUSE
NA
SOLUTION
This connection for user PUBLIC was created internally by Data Guard in attempt to resolve an archive log gap.
These sessions could be safely ignored.