V$RFS_THREAD definition in Oracle Database 11.2
V$RFS_THREAD

select
  THREAD#,                                 -- THREAD# NUMBER
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESET_TIMESTAMP,                         -- 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
  gv$RFS_THREAD
where
  INST_ID = USERENV('INSTANCE')
home |  up