User PUBLIC is detected Username Detected In Active Session on Standby database

racle Database - Enterprise Edition - Version 10.2.0.1 to 12.2.0.1 [Release 10.2 to 12.2]
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.

posted @ 2022-07-14 11:33  feiyun8616  阅读(26)  评论(0编辑  收藏  举报