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? ===== Pete Barnett Lead Database Administrator The Regence Group pnbarne@xxxxxxxxxxx _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------