Re: Optimizing Database Productivity

From: HansF <News.Hans_at_telus.net>
Date: Tue, 06 Sep 2005 13:50:01 GMT
Message-Id: <pan.2005.09.06.13.54.22.686207@telus.net>

On Tue, 06 Sep 2005 05:42:41 -0700, fl.peaches interested us by writing:

> Hello!

> I am confused about whether to set PGA_AGGREGATE_TARGET or
> SORT_AREA_SIZE. Whichever you recommend, what is the proper value for

Pretty simple really ...

If YOU want to manage it, set SORT_AREA_SIZE (and HASH_AREA_SIZE, BITMAP_MERGE_AREA_SIZE and CREATE_BITMAP_AREA_SIZE) and ensure PGA_AGGREGATE_TARGET=0. The 'Configuring SORT_AREA_SIZE' section of the 'Performance Tuning Guide and Reference' manual was written to help with this.

If you want the INSTANCE to manage it automatically, set the PGA_AGGREGATE_TARGET to a non-zero value. The value to start and how to adjust the target are well described in the 'Automatic PGA Memory Management' section of the 'Performance Tuning Guide and Reference' manual

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Tue Sep 06 2005 - 08:50:01 CDT