GV$MANAGED_STANDBY definition in Oracle 9i / www.oracledba.ru
GV$MANAGED_STANDBY
select
inst_id, -- INST_ID NUMBER
decode -- PROCESS VARCHAR2(7)
(MSTYP, 1, 'RFS', 2, 'MRP0', 3, 'MR (fg) ', 4, 'ARCH', 5, 'FGRD', 6, 'LGWR', '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', '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 (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