Re: [beginner] application with large sorts

"Brian Peasland" <dba_at_remove_spam.peasland.com> ha scritto nel messaggio news:404C6A1E.D78B69F9_at_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

Thanks a lot for your answer. Please let me ask you one more question: when the query has completed its job what will be of this space that I have used from
the TEMP tablespace ? (it will be restored....?) Thanks again
Francesco Received on Mon Mar 08 2004 - 07:41:42 CST