pga_aggregate_target

From: Peter Barnett <regdba_at_yahoo.com>
Date: Wed, 1 Sep 2004 09:08:21 -0700 (PDT)
Message-ID: <20040901160821.65903.qmail@web13422.mail.yahoo.com>

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_at_regence.com                 

---

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Sep 01 2004 - 14:19:50 CDT