Understanding the SCN values
Now Time -------> : 16:20:24
10/15/2004
Current SCN (from DBMS_FLASHBACK): 13110488
CKPT SCN (from v$database) : 13105814
Current Redo Log Begin SCN : 13105814
Redo Group Number and Status : 3
ACTIVE
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
Process SID (v$streams_capture) : 1
CAPTURE_NAME .. :
NY3_CAPTURE
State : PAUSED
FOR FLOW CONTROL
TOTAL_MESSAGES_CREATED : 17622
TOTAL_FULL_EVALUATIONS : 5138
Tot Msg Enqueued from start : 5157
Last Enqueued Messg # : 13093098
Last redo SCN flushed to the Log : 13110487
Most recently captured message : 13093098
Time when most recent msg captd : 16:20:18
10/15/2004
TOTAL_MSG_CAPT(from last start) : 7328
DNYTST10 SQL>
