Re: [beginner] application with large sorts

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 8 Mar 2004 12:42:06 GMT
Message-ID: <404C6A1E.D78B69F9@remove_spam.peasland.com>

Francesco wrote:
>
> Hi all !
> I'm going to write an application that make uses of lots of sorts
> in its queries. I don't have a deep knowdledge of Oracle Administration
> but I'm aware that an init parameter (SORT_AREA_SIZE if I remember well)
> states how much space to reserve for sorts. So I wonder, what if that space
> won't be enough : the segments reserved will "explode" like rollback
> segments do,
> or Oracle will enlarge it by itself ?
> One more question : How do I monitor if this space is going to be exausted ?
> Thanks a lot
> Francesco

If your sort exceeds SORT_AREA_SIZE, then your sort cannot be performed entirely in memory. The system will used disk to store intermediary sort results. The disk that is used is in the TEMP tablespace.

HTH,
Brian Received on Mon Mar 08 2004 - 06:42:06 CST