GV$STANDBY_APPLY_SNAPSHOT
select INST_ID, -- INST_ID NUMBER SNAPSHOT_TIME, -- SNAPSHOT_TIME DATE SESSION_ID, -- SESSION_ID NUMBER THREAD#, -- THREAD# NUMBER RESET_TIMESTAMP, -- RESET_TIMESTAMP NUMBER SEQUENCE#, -- SEQUENCE# NUMBER BLOCK#, -- BLOCK# NUMBER APPLIED_SCN, -- APPLIED_SCN NUMBER APPLIED_TIME, -- APPLIED_TIME DATE NEWEST_RESET_TIMESTAMP, -- NEWEST_RESET_TIMESTAMP NUMBER NEWEST_ARCHIVED_SEQ#, -- NEWEST_ARCHIVED_SEQ# NUMBER NEWEST_TIME, -- NEWEST_TIME DATE NEWEST_USED, -- NEWEST_USED NUMBER NEWEST_SRL_SEQ#, -- NEWEST_SRL_SEQ# NUMBER BLOCKSIZE, -- BLOCKSIZE NUMBER APPLY_RATE -- APPLY_RATE NUMBER FROM x$kcrrptdgstats

home |  up  |  mailbox