RE: shareplex replication speed up

Zhu,
We had similar issues with shareplex and were able to scale to much higher numbers by most of what you sugested. We also found that the filesystem I/O on the shareplex queue files were a bottleneck. Using hardware sriping there really helped - especially if they got large as the I/O routines of shareplex seemed to worsen the deeper the queue (i believe this has since been resolved - but you are on old software). The other thing to look at is row migration (expansion of a row causing it to relocate). This operation causes additional overhead for the capture process mostly so may not apply if capture is keeping up but posting is lagging...

Hope that helps

Bruce McCartney
403.615.3350

-----Original Message-----

    From: "zhu chao"<zhuchao_at_gmail.com>
    Sent: 11/14/05 8:22:15 AM
    To: "Oracle-L"<oracle-l_at_freelists.org>     Subject: shareplex replication speed up     

    hi, all,

        We are using shareplex to replicate transaction data. We are still     using old oracle 8174 and shareplex 3.1.4.

        We consistently see shareplex unable to keep up with primary     database so we have to slow down every batch job. We are only able to     do less than 120 transactions per second. Most transactions happen on     two core tables and there are a lot of indexes in these two tables.

       Box is running on a 12 CPU box and with tons of memory. SAN     performance is ok (less than 10ms for read and 5 ms for write).

       Currently we tried:
--increase sga as big as possible.
--rebuild index on the table to reduce index size to make it keep in
    data buffer.
--set keep buffer pool for core tables.

• we used quick IO for oracle redo log files..
• we setup multiple post queue to make parallel post.
  --the post queue process oracle sessions is mainly waiting on db file
  sequential read.

      Any other ideas to make shareplex replicate faster?     

     Regards
    Zhu Chao
    www.cnoug.org
--

    http://www.freelists.org/webpage/oracle-l               

--
http://www.freelists.org/webpage/oracle-l