Re: 64 bit vs 32 bit Oracle

!! 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 <ORACLE-L_at_fatcity.com> 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: srospo_at_watchmark.com
|
|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: 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.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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