show capture detail shows.
sp_ctrl (oel5u7x64:8606)> exit
[korcl@oel5u7x64 bin]$ date
Tue Mar 20 01:58:22 PDT 2012
[korcl@oel5u7x64 bin]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* © 2010 Quest Software, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (oel5u7x64:8606)> show capture detail
Host: oel5u7x64
Operations
Source Status Captured Since
---------- --------------- ---------- ------------------
o.stock1 Running 0 15-Mar-12 01:01:28
Oracle current redo log : 239
Capture current redo log : 239
Capture log offset : 12036696
Last redo record processed:
Operation on SHAREPLEX internal table at 03/20/12 01:58:26
Capture state : Processing
Activation id : 6
Error count : 0
Operations captured : 0
Transactions captured : 0
Concurrent sessions : 0
HWM concurrent sessions : 3
Checkpoints performed : 3576
Total operations processed : 535556
Total transactions completed : 535556
Total Kbytes read : 1821228
Redo records in progress : 0
Redo records processed : 4312152
Redo records ignored : 3776596
Redo records - last HRID : N/A
sp_ctrl (oel5u7x64:8606)> version full
SharePlex Version = 7.6.2-b59 (m64, oracle110)
sp_ctrl (oel5u7x64:8606)>
Looking at the above information the 15-Mar reffers to the time when capture was started and not where capture is processing data. The line "Last redo record processed:
Operation on SHAREPLEX internal table at 03/20/12 01:58:26" reffers to the redo record that capture is processing. In this example the current time is korcl oel5u7x64 bin]$ date Tue Mar 20 01:58:22 PDT 2012 This shows that the capture is behind 4 seconds.
This is when capture was started.
Host: oel5u7x64
Operations
Source Status Captured Since
---------- --------------- ---------- ------------------
o.stock1 Running 0 15-Mar-12 01:01:28
this is what capture is currently processing.
Last redo record processed:
Operation on SHAREPLEX internal table at 03/20/12 01:58:26
