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: http://www.orafaq.com
--
Author: Ji, Richard
INET: Richard.Ji_at_MobileSpring.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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
