Home » Server Options » Streams & AQ » Streams REQUIRED_CHECKPOINT_SCN (11g , Linux)
Streams REQUIRED_CHECKPOINT_SCN [message #403540] Sat, 16 May 2009 13:16 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member

SELECT CAPTURE_NAME, FIRST_SCN, APPLIED_SCN, REQUIRED_CHECKPOINT_SCN FROM DBA_CAPTURE
/

CAPTURE_NAME                    FIRST_SCN APPLIED_SCN REQUIRED_CHECKPOINT_SCN
------------------------------ ---------- ----------- -----------------------
STRMADMIN_CAPTURE                 5849123     5923615                 5922284



Can someone tell me why REQUIRED_CHECKPOINT_SCN is less than Applied SCN ? i created a test stream setup and configured one table in it.and made just one row deletion .

[Updated on: Sat, 16 May 2009 13:18]

Report message to a moderator

Re: Streams REQUIRED_CHECKPOINT_SCN [message #403957 is a reply to message #403540] Tue, 19 May 2009 17:26 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
I would suggest you to go through the definitions of these terms in Oracle streaming document.Please ask if you still
dont understand.
Regards,
Varun Punj,
Previous Topic: Slow Perfomance In Oracle Streams
Next Topic: Multimaster Replication using Stream
Goto Forum:
  


Current Time: Fri Mar 29 07:48:24 CDT 2024