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).