Understanding the SCN values
CAPTURE_PROFILE
-----------------------------------------------------------------
Capture_name (dba_capture) ---> :
NY3_CAPTURE
Queue Name :
NY3_QUEUE
RULE_SET_NAME :
RULESET$_156
Capture_User and Type : STRMADM
Type : LOCAL
START_SCN : 13089644
Captured_SCN : 13089673
Applied_SCN : 13089644
FIRST_SCN : 13089644
MAX_CHECKPOINT_SCN : 13091418
Reqd CKPT SCN : 13089644
Total Delta SCN
Captured : 20814
Delta SCN Applied
(Delta) : 20843
Error Number :
Error Message .. :
Now Time -------> : 16:20:24
10/15/2004
Current SCN (from DBMS_FLASHBACK): 13110487
CKPT SCN (from v$database) : 13105814
Current Redo Log Begin SCN : 13107332
Redo Group Number and Status : 1
CURRENT
Last Capt.SCN(v$streams_capture) :
13093098 At 16:19:06 10/15/2004
Last EnqueSCN (v$streams_capture):
13093098 At 16:19:06 10/15/2004