V$MANAGED_STANDBY

Monitor the progress of a standby database in managed recovery mode.

Columns
   ___________________________
 
   PROCESS
   PID
   STATUS
   CLIENT_PROCESS  (LGWR/ARCH)
   CLIENT_PID
   CLIENT_DBID
   GROUP#    (Standby redo log Group)
   THREAD#
   SEQUENCE#
   BLOCK#
   BLOCKS
   DELAY_MINS
   KNOWN_AGENTS
   ACTIVE_AGENTS

Related: