Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: pga_aggregate_target

Re: pga_aggregate_target

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 2 Sep 2004 09:44:28 +0100
Message-ID: <7765c89704090201441bfd068b@mail.gmail.com>


On Wed, 1 Sep 2004 09:08:21 -0700 (PDT), Peter Barnett <regdba_at_yahoo.com> wrote:
> 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?

I like it a lot, and it does have the distinct advantage that you can enable/disable it per session which limits the downside of using it. The PGA_ADVICE views seem to be reasonably reliable in my experience.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004
Received on Thu Sep 02 2004 - 05:42:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US