Re: [beginner] application with large sorts

"Francesco" <FrancescoNOSPAM_at_libero.it> wrote in message news:<G5Y2c.55364$Kc3.1740749_at_twister2.libero.it>...
> 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

When sort_area_size is exceeded, a temporary segment will automatically be created in your temporary tablespace. For those segments the size of your drives is the limit ;-) You can monitor sorts by using v$sort_usage.

Sybrand Bakker
Senior Oracle DBA Received on Mon Mar 08 2004 - 09:05:04 CST