GV$RFS_THREAD

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
home |  up  |  mailbox