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
Messages: 34
Registered: May 2006
Location: West Des Moines
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.
System change number (SCN) of the last captured message

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,

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

Current Time: Tue May 21 12:00:27 CDT 2024