Re: Oracle 9i tunning

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 30 Jun 2002 11:07:07 +0100
Message-ID: <1025433269.19988.0.nnrp-14.9e984b29@news.demon.co.uk>

Howard,

The 50MB boundary isn't too surprising if you check out Steve Adams' paper on sort_area_size.

Once the sort won't fit completely in memory, then the next local optimum operation is a single pass merge; and Steve's arithmetic shows that a 12GB sort can be done in a single pass with just 45MB of RAM.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Howard J. Rogers wrote in message ...


>I'd be interested in the details of those tests. Even operating system and

>version would be a start.

>

>Regards

>HJR

>

>"sg" <s4v4g3_at_europe.com> wrote in message

>news:3D1775F6.6070604_at_europe.com...

>> hi

>>

>> dont set sort_area_size too big, I have tested and setting it higher

>> than 50MB does NOT get you extra benefits

>>

>> Parallelism normally 2xCPU does fine for me, may be you can try it

>>

Received on Sun Jun 30 2002 - 05:07:07 CDT