How to check the delay in a Streams Configuration

From: Anurag Verma <anuragdba_at_gmail.com>
Date: Sun, 23 Jul 2006 19:22:53 -0500
Message-ID: <e2431aa40607231722g394811fevf0125eedd985fbe2@mail.gmail.com>

Hi All,

This is a question on Oracle 9i streams.

In the table DBA_CAPTURE table, the column descriptions for the columns CAPTURED_SCN and APPLIED_SCN
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 most recent SCN
that got applied in the target database ?

I want to know whether this information can be used to 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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 23 2006 - 19:22:53 CDT