Re: pga_aggregate_target

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 2 Sep 2004 09:44:28 +0100

On Wed, 1 Sep 2004 09:08:21 -0700 (PDT), Peter Barnett <regdba@xxxxxxxxx> 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@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - //freelists.org/archives/oracle-l/09-2004

Other related posts: