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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).