select
  primary_dbid,                            -- PRIMARY_DBID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  realtime_apply,                          -- REALTIME_APPLY VARCHAR2(64)
  state                                    -- STATE VARCHAR2(64)
from
  gv$logstdby_state
where
  inst_id = USERENV('Instance')