Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0MDNoK29018 for ; Wed, 22 Jan 2003 07:23:51 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0MDNnp29006 for ; Wed, 22 Jan 2003 07:23:49 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id CAA42519; Wed, 22 Jan 2003 02:07:06 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005370AC; Wed, 22 Jan 2003 00:33:45 -0800 Message-ID: Date: Wed, 22 Jan 2003 00:33:45 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Jonathan Lewis" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Jonathan Lewis" Subject: Re: quest SharePlex Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Very cute - this tends to suggest that Shareplex is spotting the appearance of chains in the log and storing the list of rowids. Would the same thing work if you shut down the Shareplex processes after the row had chained, and restarted them before you updated the chained piece ? And does Shareplex guarantee that it will never report a 1555 error regardless of how long it is shut down ? Your comment about supplemental logging is interesting - to me, one of the issues with using the official method for logical standby is that you have to have supplemental logging switched on at the database level. This means, as you have obviously spotted, that tables without primary keys get whole rows copied into the log. Worse still, because supplemental logging is effected through the UNDO, global temporary tables have an extra impact on the stream too. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____England______January 21/23 ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -----Original Message----- To: Multiple recipients of list ORACLE-L Date: 21 January 2003 19:01 >This is actually part of the 'magic' of SharePlex. The way we obtain the PK >information from the database if the PK was not modified is very tricky. > >1) shutdown SharePlex (stop all processes on the source machine, so >SharePlex is not even up and running) >2) insert a row. >3) update that row to cause chaining. >4) update the row again in the chained piece and don't modify the PK. >5) delete the row >6) start SharePlex back up. > >Did everything replicate successfully? Yep. :) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: jonathan@jlcomp.demon.co.uk 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: ListGuru@fatcity.com (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).