Re: 64 bit software

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 3 Sep 2004 07:14:33 +0000 (UTC)
Message-ID: <ch95kp$eiv$1@titan.btinternet.com>

Not relevant to this post, but here's a thought about migrating from 32-bit to 64-bit.

It will take more memory to perform an in-memory sort

Oracle sorting mechanism includes a tree-structure with lots of pointers. Pointer sizes double on the migration, so the tree size double.

I have a (generated data) example where an in-memory sort requires 320MB (sort_area_size) to sort in 32-bit Oracle, and 510MB to sort in 64-bit

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 2nd





"Mark Bole" <makbo_at_pacbell.net> wrote in message
news:3XFZc.14544$sx4.3166_at_newssvr27.news.prodigy.com...


> Dusan Bolek wrote:

>

> > Mark Bole <makbo_at_pacbell.net> wrote in message

news:<KRwZc.14393$9%.832_at_newssvr27.news.prodigy.com>...


> >

> >>I tried 64-bit when I tested upgrades to 9i under Solaris 8.  The basic

> >>installs and such worked fine, but when 3rd-party clients (Java, Perl)

> >>need to be re-linked, that's when the troubles started.  I retreated to

> >>32-bit.

> >

> >

> > Can you elaborate more on this? We're using only 64-bit Oracle here

> > (well, some old 32bit 8.0.5s still hanging around) and all transitions

> > were transparent. Client side should not be affected at all. Are

> > mentioned clients on the same server? Or are they on an application

> > server transferred to 64bit OS?

> >

Received on Fri Sep 03 2004 - 02:14:33 CDT