pga_aggregate_target

From: Peter Barnett <regdba_at_yahoo.com>
Date: Thu, 2 Sep 2004 06:42:11 -0700 (PDT)
Message-ID: <20040902134211.48722.qmail@web13421.mail.yahoo.com>

Has anyone used this parameter in 9i (9.2.0.4)?

I have a vended application with multiply nested unions and select distincts. The vendor has cleaned up some of the worst queries but it is still very sloppy and ineffcient.

The server is dedicated to this application's database. It has lots of RAM (12G) and CPUs (4). It hammers the CPUs pretty hard, as much as 100% utilization during prime user time. With everything taken into account, it barely uses 2G of memory. The best conclusion I can draw from mulitple analysis of statspack output is tune the application which is not possible.

Any thoughts or experience with this parameter?

---

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com                 

---

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail

---
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 - 13:00:20 CDT