ref:(Sorting)

Hi,

Default sort_area_size is 512 KB, if query sort needs more space like 10-15 MB then temp segment is used right.
If I increase the sort_area_size to 15 MB for the session where the sort is being done then will temp segment be used?.

Another one re-building ,creating index.
----------------------------------------------

The field I am going to create an index has around 1 million records, if I increase the sort_area_size to size of the field then will temp segment be used ?.

Since we have enough physical memory, I would like to reduce temp segment usage in tem table space as much I can.

If about points are correct then do I have to maintain sort_area_retain size equal to sort_are_size?.

Please clear my questions.


Thanks,

http://technet.oracle.com/docs/produ...9_mem.htm#2130

http://technet.oracle.com/docs/produ...20_io.htm#3689

HTH.