> 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? > Hi Pete, We're using it on out SAP databases. No problems. Here are some scripts I used to gauge where to set the initial target value. http://www.cybcon.com/~jkstill/util/scripts/pga_target.html HTH Jared ---------------------------------------------------------------- To unsubscribe send an email to: oracle-l-request@xxxxxxxxxxxxx and put 'unsubscribe' in the subject line. ----------------------------------------------------------------