I set the sort area reatined size to 0 after dropping the sort area size.


Looks like MTS is a good option - does this required tnsnames client changes? i.e. logon different listener

I also consired stack changes, but this made me a little nervous.

I am using windows 2000 advanced server. Without the /pae /3gb the db would not even open with large buffer cache settings. (same as nt with /3gb switch)