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
