<FYI_Verify> Oracle 9i introduced auto tunning of PGA and can be enabled by setting the PGA_AGGREGATE_TARGET. It frees quite a bit of RAM. Also Oracle recommends to use this instead of sort_area_size and can be set online. It can be estimated and set as follow: 1. Set the PGA_AGGREGATE_TARGET to (select value from v$pgastat where name = 'total PGA allocated';) 2. It can further be tuned using v$pga_advice. Use this table to find out more appropriate value where the ESTD_OVERALLOC_COUNT is 0 and ESTD_PGA_CACHE_HIT_PERCENTAGE is near 100. </FYI_Verify> HTH GovindanK On Wed, 1 Sep 2004 09:08:21 -0700 (PDT), "Peter Barnett" <regdba@xxxxxxxxx> said: > Has anyone used this parameter in 9i (9.2.0.4). I > have a real turkey of a vended application that is a > resource hog. The queries have too many outer joins, > select distincts and minus's to count. Usually, all > in the same query. > > With no control over the application, if this > parameter works as advertised, this seems like a good > place to use it. > > Any experiences or thoughts? > > > ===== > Pete Barnett > Lead Database Administrator > The Regence Group > pnbarne@xxxxxxxxxxx > > > > _______________________________ > Do you Yahoo!? > Win 1 of 4,000 free domain names from Yahoo! Enter now. > http://promotions.yahoo.com/goldrush > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------