RE: now what??

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Tue, 24 Aug 2004 17:05:44 -0500
Message-ID: <433A07749711884D8032B6A0AB115262C2BD42@conmsx07.corp.acxiom.net>

Robyn,

        Just wondering how much memory is on these servers and if you're doing much parallel processing?

        Also, if you think you have too many CPUs and have more than just the database on a server, you may look at the man pages for psrset. Should be in /usr/sbin. This lets you restrict what CPUs an app can have. I think you could also make a case for reducing your license costs.

Same command on Solaris - TRU64 is pset

        Larry

"The databases are very large, 500 and 800 gb's or so. The equipment is not bad: 8 cpu
HP-UX boxes with emc storage. The db's are 9.2.0.3 and will soon be patched to 9.2.0.5. (test db has already been patched and several key queries perform better with the patch)"

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

---

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 Tue Aug 24 2004 - 17:02:32 CDT