• From: Peter Barnett <regdba@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 1 Sep 2004 09:08:21 -0700 (PDT)

Has anyone used this parameter in 9i (  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?

Pete Barnett
Lead Database Administrator
The Regence Group

Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: