In the init.ora file called sort_area_size The larger it is the less it
will sort to disk. It is in bytes and it is PER connection. So if you
increase it by 2,000,000 and you have 100 connections then you could use up
to 200 meg more ram. Also look at the drive the temporary tablespace is on;
make sure you minimize contention there.
Jim
"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in
message news:3c0f9188.1473297750_at_news.alt.net...
> Oracle 8.1.6
>
> We just added some memory to out server, and have not really noticed
> Oracle making use of that memory. I assume there are a number of
> parameters to be tweaked, and I'll need to do some reading.
>
> In the meanwhile, we'd specifically like to speed up sorts. Is there
> one parameter that tweaks its usage, or is it more than than one?
> Would someone be kind enough to point out their names (so I can read
> what they are in the documentation on initialization parameters) or
> with a pointer to something in the documentation that deals
> specifically with physical memory usage?
>
> Brian
Received on Thu Dec 06 2001 - 09:58:29 CST
