How far is shareplex behind Oracle? (4244292)

How far is shareplex behind Oracle?

How far is shareplex capture process behind Oracle?

FOR NON_RAC:

sp_ctrl> show capture detail

OR run this query 'select seqno from shareplex_actid;' and 'select sequence#, status from v$log;'

This will show where Capture is currently at in Oracle vs. where Oracle is at.

sp_ctrl (linux05:8606)> show capture detail

Host: linux05
Operations
Source Status Captured Since
---------- --------------- ---------- ------------------
o.stock Running 0 11-Oct-04 09:05:18

Oracle current redo log : 987
Capture current redo log : 987
Capture log offset : 41782220
Last redo record processed:
Operation on SHAREPLEX internal table at 10/11/04 11:30:14

Capture state : Waiting
Activation id : 70
Error count : 0
Operations captured : 0
Transactions captured : 0

Concurrent sessions : 12
HWM concurrent sessions : 16
Checkpoints performed : 73
Total operations processed : 16721
Total transactions completed : 16721

Redo records in progress : 0
Redo records processed : 134523
Redo records ignored : 117802
Redo records - last HRID : N/A

For RAC:
This shows where redo logs/archive logs Capture is currently reading .

SQL> select instance_name, seqno from shareplex_actid;

INSTANCE_NAME SEQNO
---------------- ----------
suprac1 833
suprac2 809

Show capture detail shows which log oracle is currently on or you can query 'select thread#, sequence#, status from v$log;' to find out.

sp_ctrl (splexv:2300)> show capture detail

Host: splexv
Operations
Source Status Captured Since
---------- --------------- ---------- ------------------
o.splex Running 153306 05-Jan-07 10:49:52

Thread Instance Host Redo Log Log Offset
------ ------------ ------------ -------- ----------
1 suprac1 alvsupu10 833 46276872
2 suprac2 alvsupu11 809 19489860

Oracle current redo log : 833
Capture current redo log : 809
Capture log offset : 19486788
Last redo record processed:
Operation on SHAREPLEX internal table at NA

Capture state : Waiting
Activation id : 29
Error count : 0
Operations captured : 153306
Transactions captured : 76653

Concurrent sessions : 0
HWM concurrent sessions : 3
Checkpoints performed : 2115
Total operations processed : 290409
Total transactions completed : 213756

Redo records in progress : 0
Redo records processed : 1916047
Redo records ignored : 1625638
Redo records - last HRID : AAATGmAAEAAADeXAEJ

ADDITIONAL INFORMATION:

Refer solution 26719 for details about SQL queries to determine the capture current redo log and Oracle current redo log..