Re: pga_aggregate_target

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 - http://freelists.org/archives/oracle-l/09-2004

Other related posts: