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