Re: sort_area_size

"@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 Received on Fri Apr 06 2001 - 14:33:40 CDT