Parameter affecting Memory Usage for sorts

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:46:37 CST