RE: SharePlex Summary

Allan

   As to your Shareplex comments, I'm in no position to support or refute your conclusions. My admittedly brief experience with replication leads me to the conclusion that there are no simple conclusions. If ever there was an area where "your mileage may vary", this is it. Replication is a simple label that is stuck to a vast array of situations. I feel it important for your organization to define what it wants to do, and then pick the technology, rather than pick the "best" technology and then attempt to adapt it to your needs. It is possible that there are situations where Shareplex will work like no other, and other situations where basic Oracle features achieve all the desired goals. In my readings, it seems like most of the replication projects that either fail or cause a lot of problems are those where the organization tries to "flip the replication switch", rather than treating it as a serious project that requires cooperation of many different areas of the organization. But then as I said at first, I'm no expert.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, August 12, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L

Actually, I suspect I will be able to do the testing myself before I get more back from those guys.

Matthew Zito made a good point in another reply to this message saying that 32 bit addresses had to be translated to 64 bit addresses because of architecture requirements so you would still have a one cycle instruction fetch (neglecting cache misses and wait states for access from slow main memory).

Building on that, perhaps address translation might be the problem. 32 bit addresses map you into 4GB of memeory. Those 4GB segments would be mapped into the 64 bit CPU's larger address space. I don't know PA RISC assembler or register sets but something like a TLB would be needed. It would be odd if that accounted for a 20 - 25% overhead.

Similarly there would probably be some io space remapping as well. Quien Sabe? I will be able to run side by side instances on the test box to check it out. Maybe some of the listers would be interested in the results.

Allan

-----Original Message-----
Sent: Tuesday, August 12, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L

 Frankly, that does not sound logical to me, but I would be extremely interested if there is any authenticity to the statement.

I would ask the individual who made the statement to provide the proof. I can't stop envisioning this on the next myth list.

       PST Please respond to ORACLE-L_at_fatcity.com

Sent by: ml-errors_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:

First thanks to every one who responded both on the list and to my private email:

The consensus appeared to be:
1.  SharePlex is overly expensive for the functionality delivered and 2.  Oracle has caught up in 9i for much of the functionality 3.  Some features of Oracle like IOT's may present some problems.

We are on HPUX and 9i is 64 bit only on that platform.  I have been told that the 64bit code imposes a 20 - 25% performance penalty vs the 32 bit version of 8.1.7.  Can anyone address this from experience?

   Allan L. Nelson
   Oracle DBA
   M-I L.L.C.
   (832) 295-2238 office
   (832) 351-4180 fax
   anelson_at_midf.com <mailto:anelson_at_midf.com>

American Express made the following
 annotations on 08/12/2003 01:10:13 PM

--


****************************************************************************

**


     "This message and any attachments are solely for the intended recipient
and may contain confidential or privileged information. If you are not the
intended recipient, any disclosure, copying, use, or distribution of the
information included in this message and any attachments is prohibited.  If
you have received this communication in error, please notify us by reply
e-mail and immediately and permanently delete this message and any
attachments.  Thank you."



****************************************************************************

**



============================================================================
==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tracy Rahmlow
  INET: tracy.rahmlow_at_aexp.com

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_at_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).


____________________________________________________________________________
__
This email is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Copying, forwarding or distributing this message by persons or entities
other than the addressee is prohibited. If you have received this email in
error, please contact the sender immediately and delete the material from
any computer.  This email may have been monitored for policy compliance.
[021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: anelson_at_midf.com

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_at_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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_at_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).