select
  INST_ID,                                 -- INST_ID NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  RESETLOG_SCN,                            -- RESETLOGS_CHANGE# NUMBER
  RESETLOG#,                               -- RESET_TIMESTAMP NUMBER
  LAST_REDO_SEQ#,                          -- LAST_REDO_SEQ# NUMBER
  LAST_REDO_BLK#,                          -- LAST_REDO_BLK# NUMBER
  LAST_REDO_TIME,                          -- LAST_REDO_TIME DATE
  LOW_GAP_SCN,                             -- LOW_GAP_SCN NUMBER
  LOW_GAP_TIME,                            -- LOW_GAP_TIME DATE
  LAST_PING_TIME                           -- LAST_PING_TIME DATE
FROM
  x$krfsthrd