Home » Server Options » Streams & AQ » Streams -- How to check the delay
Streams -- How to check the delay [message #174217] Fri, 26 May 2006 09:53
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member
Hi All,


The column descriptions for the columns CAPTURED_SCN and APPLIED_SCN in the table DBA_CAPTURE gives the following description in Oracle Documentation.
===============================================================
CAPTURED_SCN
NUMBER
System change number (SCN) of the last captured message

APPLIED_SCN
NUMBER
System change number (SCN) of the most recent message dequeued by the relevant apply processes. All changes below this SCN have been dequeued by all apply processes that apply changes captured by this capture process.
===============================================================

What my doubt is that if I check the DBA_CAPTURE view in the source
database for the above columns, does the column value for APPLIED_SCN give the correct SCN that applied in the target
database that is hosted in a remote server?

I want to know this information, so that I can immediately track the DELAY between the source CAPTURE process and the target APPLY process ?

Also, anybody can give me any good documentation or links for monitoring Streams performance ?

Thanks in advance,

Anurag
Previous Topic: ORA-604 During dropping a Propagation
Next Topic: Message always in ready state
Goto Forum:
  


Current Time: Thu Mar 28 18:27:26 CDT 2024