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 Received on Mon Nov 14 2005 - 09:24:15 CST