GV$STANDBY_LOG

select
inst_id,                 -- INST_ID NUMBER
slnum,                   -- GROUP# NUMBER
slthr,                   -- THREAD# NUMBER
slseq,                   -- SEQUENCE# NUMBER
slsiz*slbsz,             -- BYTES NUMBER
slnab*slbsz,             -- USED NUMBER
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