GV$STANDBY_LOG

select
inst_id,                 -- INST_ID NUMBER
slnum,                   -- GROUP# NUMBER
decode                   -- DBID VARCHAR2(40)
  (slpdb, 0, 'UNASSIGNED', to_number (slpdb)),
slthr,                   -- THREAD# NUMBER
slseq,                   -- SEQUENCE# NUMBER
slsiz*slbsz,             -- BYTES NUMBER
decode                   -- USED NUMBER
  (slnab, 0, 0, (slnab-1) *slbsz),
decode                   -- ARCHIVED VARCHAR2(3)
  (bitand (slflg, 1), 0, 'NO', 'YES'),
decode                   -- STATUS VARCHAR2(10)
  (sign (slseq), 0, 'UNASSIGNED', 'ACTIVE'),
to_number (sllos),       -- FIRST_CHANGE# NUMBER
to_date                  -- FIRST_TIME DATE
  (sllot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (slnxs),       -- LAST_CHANGE# NUMBER
to_date                  -- LAST_TIME DATE
  (slnxt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') 
from
x$kccsl
home |  up  |  mailbox