GV$MANAGED_STANDBY

select
inst_id,                 -- INST_ID NUMBER
decode                   -- PROCESS VARCHAR2(9)
  (MSTYP, 1, 'RFS', 2, 'MRP0', 3, 'MR (fg) ', 4, 'ARCH', 5, 'FGRD', 6, 'LGWR', 7, 'RFS (FAL) ', 8, 'RFS (NEXP) ', 9, 'LNS', 'UNKNOWN'),
to_number (MSPID),       -- PID NUMBER
decode                   -- STATUS VARCHAR2(12)
  (MSSTS, 0, 'UNUSED', 1, 'ALLOCATED', 2, 'CONNECTED', 3, 'ATTACHED', 4, 'IDLE', 5, 'ERROR', 6, 'OPENING', 7, 'CLOSING', 8, 'WRITING', 9, 'RECEIVING', 10, 'ANNOUNCING', 11, 'REGISTERING', 12, 'WAIT_FOR_LOG', 13, 'WAIT_FOR_GAP', 14, 'APPLYING_LOG', 'UNKNOWN'),
decode                   -- CLIENT_PROCESS VARCHAR2(8)
  (MSPAR, 0, 'N/A', 4, 'ARCH', 5, 'Archival', 6, 'LGWR', 9, 'LNS', 'UNKNOWN'),
decode                   -- CLIENT_PID VARCHAR2(40)
  (MSPPID, 0, 'N/A', to_number (MSPPID)),
decode                   -- CLIENT_DBID VARCHAR2(40)
  (MSDBID, 0, 'N/A', to_number (MSDBID)),
decode                   -- GROUP# VARCHAR2(40)
  (MSLNO, 0, 'N/A', to_number (MSLNO)),
to_number (MSRLC),       -- RESETLOG_ID NUMBER
to_number (MSTHR),       -- THREAD# NUMBER
to_number (MSSEQ),       -- SEQUENCE# NUMBER
to_number (MSBNO),       -- BLOCK# NUMBER
to_number (MSBCT),       -- BLOCKS NUMBER
to_number (MSDLY),       -- DELAY_MINS NUMBER
to_number (MSRCLT),      -- KNOWN_AGENTS NUMBER
to_number (MSACLT)       -- ACTIVE_AGENTS NUMBER
from
x$kcrrms
home |  up  |  mailbox