Re: How to check the delay in a Streams Configuration
- From: "Arul Ramachandran" <contactarul@xxxxxxxxx>
- To: anuragdba@xxxxxxxxx
- Date: Mon, 24 Jul 2006 22:38:57 -0700
I am not sure if there is a way to get this info from the dictionary.
However, you may want to set up a heartbeat table - sort of a dummy/tiny
table that is part of your streams replication setup, that get
inserts/updates to a date/timestamp field via a dbms_job every minute or so
at the source. You can verify the value of this field at the target and
compare this with sysdate.
In any case, having a heartbeat table would be necessary to validate/monitor
the health of streams replication.
Regards,
Arul
On 7/23/06, Anurag Verma <anuragdba@xxxxxxxxx> wrote:
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
l
Other related posts:
