pga_aggregate_target

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: