** replication slow

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Fri, 8 Aug 2008 21:16:48 -0700 (PDT)
Message-ID: <134367.12176.qm@web58002.mail.re3.yahoo.com>


Hi,

 Adv replication (version 9i, high usage OLTP) works fine most of the time and sometimes falls behind. Looks like it is doing different number of transactions/min at different times. There is no real difference in transaction size from time to time. Is there a way to know where the bottleneck is ? And more importantly how to improve it. So as to atleast have some consistency. Yes, I did the usual statspack, checking the tables etc. looking at metalink notes. Thanks                    

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 08 2008 - 23:16:48 CDT

Original text of this message