You have to be careful with SORT_AREA_SIZE. Each user that logs in gets
that amount of memory allocated to them, so if you have lots of users, you
have to have lots of memory.
--
John Jones
Senior Oracle DBA
Duke University OIT
john.jones_at_duke.edu
"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message
news:39BFC0B0.9A9691EA_at_edcmail.cr.usgs.gov...
>
>
> > Sounds like you are doing lots of sorts and/or index builds. You may be
> > able to minimize sorting via indexes. Get the SQL from v$sql with the
> > highest number of sort i/o's, and perform explain plans on it.
>
> One could also increase the SORT_AREA_SIZE to cause more sorts to be
> performed in memory rather than on disk.
>
> HTH,
> Brian
>
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Thu Sep 14 2000 - 07:12:44 CDT
