Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> some pitfalls about quest Shareplex . any suggestions or more pitfalls

some pitfalls about quest Shareplex . any suggestions or more pitfalls

From: jame tong <jametong_at_gmail.com>
Date: Mon, 6 Jun 2005 10:43:24 +0800
Message-ID: <264ff9340506051943731475b9@mail.gmail.com>


When using quest shareplex software, I found the following problems . anyone has any suggestions or have anyone met some other pitfalls with shareplex. why not share it with me!!

  1. Of character convertion. Shareplex can easyly convert from us7ascii to our zhs16gbk characterset with varchar2,varchar2,char etc.. but when using it with the clob type . the characters then can't be identified..
  2. when used with clob type , the shareplex software will not use bind vars to insert data into the destination database. This bring so much pressure on the shared pool of our system.
  3. when update 200,000 records of our test table . the shareplex software gererated more than 2000 child cursors with the same hash value.

How can I solve these problems .=20

Best regards.

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jun 05 2005 - 22:48:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US