select
  PROCESS,                                 -- PROCESS VARCHAR2(9)
  PID,                                     -- PID NUMBER
  STATUS,                                  -- STATUS VARCHAR2(12)
  CLIENT_PROCESS,                          -- CLIENT_PROCESS VARCHAR2(8)
  CLIENT_PID,                              -- CLIENT_PID VARCHAR2(40)
  CLIENT_DBID,                             -- CLIENT_DBID VARCHAR2(40)
  GROUP#,                                  -- GROUP# VARCHAR2(40)
  RESETLOG_ID,                             -- RESETLOG_ID NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  BLOCK#,                                  -- BLOCK# NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  DELAY_MINS,                              -- DELAY_MINS NUMBER
  KNOWN_AGENTS,                            -- KNOWN_AGENTS NUMBER
  ACTIVE_AGENTS                            -- ACTIVE_AGENTS NUMBER
from
  GV$MANAGED_STANDBY
where
  inst_id = USERENV('Instance')