Determine if Shareplex and Oracle are on the same redo log (4325771)

Determine if Shareplex and Oracle are on the same redo log

Shareplex for Oracle all versions: This sql statement can be used to determine if Shareplex is falling behind Oracle in processing the redo logs.

seqno from the shareplex_actid is the redo log sequence number Shareplex is currently on.
sequence# from v$log where status=CURRENT is the redo log sequence number Oracle is currently on.

Issue this sql statement...

select sequence#-seqno "Logs Shareplex is behind" from shareplex_actid,v$log where status=CURRENT;

Logs Shareplex behind
---------------------
0

This will return a value of how many redo logs Shareplex is behind oracle. If the number is 0, then you are caught up in processing the redo logs.