Sort area size

Giganews Newsgroups
Subject: Sort area size
Posted by:  Oradba Linux (techiey2…
Date: Sat, 8 Jan 2005

I have my sort area size set to 1MB. I look at v$sort_segment and i have a
lot of users using the temp tablespace.
My db block size is 8k. The users using the temp segments are using 128
extents.which is about 1M.
The extent sizes in temp tablespace is 1MB. So theoretically if i increase
the size of sort_area_size to more then 1MB (say 2MB)
will all these sorts fit into memory. I am not trying to see a rapid
increase in performance here by changing that.
Right now 99% of my sorts are in memory.