sort_area_retained_size

[jayeshdba]

Hi Friends,

I am confusing in understanding oracle

sort_area_retained_sizr init ora parameter .

Large sorts r happening in my database.

so i set sort_area_size =250 M

now after sort completes i want to fully release this space.

So what should i specify in sort_area_retained_size ?

sort_area_retained_size = 0 or

sort_area_retained_size = 250 M .

Thanks

Jayesh

[pando]

kidding... 250MB for sort area size..? it's per session. if you have 10 users sorting you might use 2.5gb ram :P
Anyway if you set retained size small you free the memory after each sorts