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