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