Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 19360 invoked from network); 8 Aug 2008 23:18:53 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 8 Aug 2008 23:18:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A79E8E6920; Sat, 9 Aug 2008 00:18:48 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08472-04-29; Sat, 9 Aug 2008 00:18:47 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 694DA8E6923; Sat, 9 Aug 2008 00:18:47 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 09 Aug 2008 00:16:51 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DEAA48E6544 for ; Sat, 9 Aug 2008 00:16:50 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07790-02-2 for ; Sat, 9 Aug 2008 00:16:50 -0400 (EDT) Received: from web58002.mail.re3.yahoo.com (web58002.mail.re3.yahoo.com [68.142.236.110]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 118158E653A for ; Sat, 9 Aug 2008 00:16:49 -0400 (EDT) Received: (qmail 12848 invoked by uid 60001); 9 Aug 2008 04:16:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID; b=ZgLN4QYZytoLQojmDHmvUOiPNfxps9ZdH9D8dOjz5JJ8GJ8t6ppQgZ1OaVWcbJSvSgFaaOfaFMFkxbxQYsVeeUTydjB9J6AoBapmKdsCWHimvYplVCoa1Xvud5/UVu0+OVU8af7hj6GFIFcNcFNrixUxGD6W8moUKKKJAFA7OB4=; Received: from [192.128.167.68] by web58002.mail.re3.yahoo.com via HTTP; Fri, 08 Aug 2008 21:16:48 PDT Date: Fri, 8 Aug 2008 21:16:48 -0700 (PDT) From: A Joshi Subject: ** replication slow To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-824832869-1218255408=:12176" Message-ID: <134367.12176.qm@web58002.mail.re3.yahoo.com> X-archive-position: 10024 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ajoshi977@yahoo.com Precedence: normal Reply-to: ajoshi977@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --0-824832869-1218255408=:12176 Content-Type: text/plain; charset=us-ascii 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 --0-824832869-1218255408=:12176 Content-Type: text/html; charset=us-ascii

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

--0-824832869-1218255408=:12176-- -- http://www.freelists.org/webpage/oracle-l