Re: >sort_area_size

In <tcs6crars3o8a5_at_beta-news.demon.nl> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:

>"@nnibale" <annibale_at_ifrance.com> wrote in message
>news:9al2fc$kuq$1_at_aldebaran.worldonline.fr...
>> hi,
>>
>> how to determinate the "good" value for the parameter sort_area_size ?
>> ( oracle 8.0.4 on digital unix 4.0c with 2Go ram)
>>
>> Regards.
>>
>> @nnib
 

>By running utlbstat/utlestat, and determining the number of memory sorts
>against the number of disk sorts.
>However 1M should usually be sufficient and more doesn't buy you much. And
>of course you can always change it on session level by
>alter session set sort_area_size = <anything humongous> if you really want
>your server have to choke.
 

>Hth,
 

>Sybrand Bakker, Oracle DBA

Sybrand,

Could you please expand your "and more doesn't buy you much" statement. I have users with seemingly psychotic sorting needs/sizes. If I'm wasting memory vs. disk sorts I'd love to know! =:-)

Thanks in advance.

Scott Gallaher <scott.gallaher_at_west.boeing.com> Boeing Imperial Oracle DBA and TECO Wizard "Quondo Omni Flunkus Mortati" Received on Fri Apr 06 2001 - 15:39:38 CDT