Oracle-L: RE: SharePlex Summary

From: Nelson, Allan <anelson_at_midf.com>
Date: Tue, 12 Aug 2003 13:39:23 -0800
Message-ID: <F001.005CA53A.20030812133923@fatcity.com>

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
---------------------------------------------------------------------