Sort_area_size useful if using dedicated server connection?

Printable View

07-02-2003, 09:27 PM
richyip

Sort_area_size useful if using dedicated server connection?

Hi,

I have installed Oracle 9.2.0.1.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.
07-03-2003, 02:56 AM
ggnanaraj

Re: Sort_area_size useful if using dedicated server connection?

Quote:

Originally posted by richyip
Now, I'm wondering whether sort_area_size is used or PGA is used instead?

What do you mean by the above ?:rolleyes:
07-03-2003, 03:32 AM
richyip

I mean to ask:

Does Oracle 9.2.0.1 use sort_area_size or PGA for sorting operations? If PGA is used, then is the sort_area_size useful in performance tuning?
07-03-2003, 03:39 AM
jovery

http://tahiti.oracle.com/pls/db92/db...or.htm%2320461
07-03-2003, 07:05 AM
richyip

Quote:

Originally posted by jovery
http://tahiti.oracle.com/pls/db92/db...or.htm%2320461

But then does the sort_area_retained size is used in 9iR2? It is useful in Oracle 8i.

All times are GMT -4. The time now is 07:15 PM.