Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> FW: urgent help: replication, shareplex

FW: urgent help: replication, shareplex

From: Ji, Richard <>
Date: Mon, 30 Sep 2002 09:28:26 -0800
Message-ID: <>

Oh, and I forgot to add that the table that's being replicated is partitioned in the repository database.
with local indexes. Each partition holds a day worth of volume.

> -----Original Message-----
> From: Ji, Richard
> Sent: Monday, September 30, 2002 12:08 PM
> To: Multiple recipients of list ORACLE-L (E-mail)
> Subject: urgent help: replication, shareplex
> Hi All,
> I needed some help here involving shareplex.
> We run two databases (an OLTP type, and a repository type) on the same
> E10K domain
> which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is
> being used
> to replicate a table from the OLTP type to the repository. The current
> volume we are getting
> is about 40 inserts per second to the OLTP. And at this rate shareplex is
> lagging behind
> doing the replication, for 24 hours now. And I see the shareplex process
> running at 10%
> while all Oracle processes are below 1% of the CPU.
> The situation is complicated, because it involves a hosting company. For
> instance, I would
> like to run the two databases on two separate domains but they chose not
> to. So they
> are blaming our application for doing commit on every insert being the
> problem. I agree that
> (and I will make the change) to commit every 1000 inserts or so. However,
> I don't believe
> that's the root of the problem. From what I understand, shareplex is log
> based replication
> and should not be as resource instensive. And 40 per/second isn't a huge
> volume per se
> and I am sure shareplex can handle a lot more than that.
> So any suggestions, feedbacks are welcome.
> Thanks
> Richard

Please see the official ORACLE-L FAQ:
Author: Ji, Richard

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 30 2002 - 12:28:26 CDT

Original text of this message