RE: now what??

  • From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 24 Aug 2004 17:05:44 -0500

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@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
-----------------------------------------------------------------

Other related posts: