Re: >sort_area_size

<scott.gallaher_at_west.boeing.com> wrote in message news:GBE1E2.F2v_at_news.boeing.com...
> 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"

Scott,

As Mr. Sanchez seems to know *everything*, I will unsubscribe in a few minutes, and leave this group to him.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Apr 07 2001 - 15:02:06 CDT