Optimizing Database Productivity
From: fl.peaches <fl.peaches_at_gmail.com>
Date: 6 Sep 2005 05:38:34 -0700
Message-ID: <1126010314.585461.122100_at_o13g2000cwo.googlegroups.com>
Hello!
[Quoted] 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
Date: 6 Sep 2005 05:38:34 -0700
Message-ID: <1126010314.585461.122100_at_o13g2000cwo.googlegroups.com>
Hello!
[Quoted] 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 - 14:38:34 CEST