How to determine the capture current Redo log (4263596)

Is there a way to determine which redo log Shareplex capture process is processing.

Show capture detail command output shows the capture current redo log and Oracle current redo log, this can help you determine which log capture is currently reading.

If you need to query the database then Shareplex _actid table has the log seq number that capture is currently reading.

NON RAC:

select seqno, instance_name from shareplex_actid;
select sequence# from gv$log where status='CURRENT';

RAC:

You have to determine which redo log capture is currently on for Each node of RAC.

select seqno, instance_name from shareplex_actid;
select instance_name, status,thread# from gv$instance;
select sequence#, thread# from gv$log where status='CURRENT';

ADDITIONAL INFORMATION:

Refer solution 196 for details about show capture detail.