Re: ** replication delay analysis
- From: mkb <mkb125@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 2 Mar 2005 12:47:52 -0800 (PST)
--- A Joshi <ajoshi977@xxxxxxxxx> wrote:
> I am trying to analyze replication delay. It is
> advanced two way replication implemented one-way
> only so data goes from source to target.
Wait a minute. How can it be advanced two way
replication if it is only implemented one-way?
> Is there a way to know how much deftran has reached
> the target and waiting to be executed. Currently the
> deftran at source is increasing and is that
> indication that source is the problem?
Not the best tool to use, but try using OEM to see if
the trxns have been pushed to your target. You may
also see them on the replication map in OEM.
Could also be a huge trxn that took place at the
source. I've seen replication get stuck when you try
mass deletes/updates (millions of rows). Check to see
if defcall is increasing.
--
mohammed
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
