Hi all ,

In my production system, initilzation values for
sort_area_size and sort_area_retain_size is as follows

sort_area_size 264000
sort_area_retained_size 65536

In one oracle reference I saw the recomendation that
sort_area_retained_size should be smaller than sort_area_size. But in another documentation I saw that sort_area_size should be equal to sort_area_retained size,
unless you are extremely short of ram. Otherwise shrinking
and growing of sort area willl give a performance hit to the system

Which of the above statement is more valid. In my case I
have 512 Mb of Ram in my production system. What is best for me ?

Regards