From oracle-l-bounce@freelists.org Mon Jun 6 05:53:33 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j56ArX6p019246 for ; Mon, 6 Jun 2005 05:53:33 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j56ArXNi019242 for ; Mon, 6 Jun 2005 05:53:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4949A1BACA3; Mon, 6 Jun 2005 04:50:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23636-06; Mon, 6 Jun 2005 04:50:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB2521BB3F0; Mon, 6 Jun 2005 04:50:23 -0500 (EST) content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 Subject: RE: some pitfalls about quest Shareplex . any suggestions or more pitfalls Date: Mon, 6 Jun 2005 10:48:25 +0100 Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63011A1842@UKWMXM04> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: some pitfalls about quest Shareplex . any suggestions or more pitfalls Thread-Index: AcVqQa3f0Z7Pm/TIQDWX/biowqwp/QAOq1aw From: "Hallas, John, Tech Dev" To: , "ORACLE-L" X-OriginalArrivalTime: 06 Jun 2005 09:48:26.0060 (UTC) FILETIME=[E2A0B8C0:01C56A7C] X-archive-position: 20682 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: John.Hallas@gb.vodafone.co.uk Precedence: normal Reply-To: John.Hallas@gb.vodafone.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.63 Which version of Shareplex are you using?, the latest one. There are a couple of Shareplex (Quest) staff who monitor this list but have you spoken to Quest directly about your issues? What is their response. I have found that once given a good test case they work hard to resolve any issues within their control. I think it fair to say, certainly in my experience, you need to be able to prove there is a problem first, which can be quite difficult. >>>>>>>>>> Subject: some pitfalls about quest Shareplex . any suggestions or more pitfalls 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 . -- http://www.freelists.org/webpage/oracle-l