!! Please do not post Off Topic to this List !!
My experience to date is that Oracle 9i running
on 64-bit hp-ux 11 runs at about half the speed
of Oracle 8.1.7 running on 32-bit hp-ux.
I also have a test on Sun showing 9.0.1 on
64-bit Solaris running 20% slower than
8.1.7 on 64-bit Solaris; and at speed which
suggest that it is the 32/64 bit change that
causes most of the degradation.
I have yet to install 8.1.7 on 64-bit hp-ux
and compare it with the other two hp-ux
setups.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 14 September 2001 20:12
|!! Please do not post Off Topic to this List !!
|
|
|Is there any benefit of 64 bit versions over 32 bit versions of
Oracle
|beyond allowing > 2GB SGAs? (8.1.7/Solaris 2.8 in particular) The
|systems I'm working with are predominantly DSS queries against data
sets
|that most of the servers have no hope of caching anywhere near the
amount
|of data needed so huge SGAs are not that useful. Our C++ guys tell
me
|that Sun reccommends that compiling 64 bit binaries for processes
that
|might take advantage of the larger memory limit. The logic being
that 64
|bit pointers take up twice as much space as 32 bit pointers and the
|processor cache density is thus lower for 64 bit processes.
|
|Does anyone know if there is any additional trickery Oracle does on
the
|64-bit port that may provide performance benefits that would outweigh
the
|potential for lower cache hit rates? Magic data structures?
|_make_sql_faster support?
|
|S-
|
|
|
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Steve Rospo
| INET: [EMAIL PROTECTED]
|
|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing
Lists
|--------------------------------------------------------------------
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (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.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
