Hello!
I am confused about whether to set PGA_AGGREGATE_TARGET or
SORT_AREA_SIZE. Whichever you recommend, what is the proper value for
the continuous running of the multiple applications for a database that
is sized between 6GB and 10GB? If you recommend using the
SORT_AREA_SIZE what is the proper value for the corresponding
SORT_AREA_RETAINED_SIZE?
Currently my system is set to values as follows:
sort_area_size : 346640 bytes
Thanks for any help you can give.
Received on Tue Sep 06 2005 - 07:42:41 CDT
