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