Sort_area_size useful if using dedicated server connection?
I have installed Oracle 22.214.171.124.0 as dedicated server. I notice the PGA usage is about 50MB 50 150MB. Now, I'm wondering whether sort_area_size is used or PGA is used instead? Is the sort_area_retained size useful in a dedicated server environment? The current size is 0. Sort_area_size is 512K. Tks.
Re: Sort_area_size useful if using dedicated server connection?
What do you mean by the above ?
Originally posted by richyip
Now, I'm wondering whether sort_area_size is used or PGA is used instead?
I mean to ask:
Does Oracle 126.96.36.199 use sort_area_size or PGA for sorting operations? If PGA is used, then is the sort_area_size useful in performance tuning?
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
But then does the sort_area_retained size is used in 9iR2? It is useful in Oracle 8i.
Click Here to Expand Forum to Full Width