RE: Limiting CPUs on SUN

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 May 2004 13:48:04 -0400

Justin has a good point.  Even if you can create a processor set
with just X CPUs, and get all the oracle processes to bind to that
processor set, you'll still need to convince Oracle that you're in=20
compliance. ;-)

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"


-----Original Message-----
From: Justin Cave (DDBC) [mailto:jcave@xxxxxxxxxxx]=20
Sent: Wednesday, May 12, 2004 1:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Limiting CPUs on SUN


CPU_COUNT won't limit Oracle to running on a subset of CPU's.

If my reading of the Oracle licensing materials is correct (I don't even
play a lawyer on TV), Oracle ignores any software partitioning in place
when assessing license fees.  If you have X+14 CPUs, Oracle will do its
best to assess X+14 CPU licenses.


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfson Larry -
lwolfs
Sent: Wednesday, May 12, 2004 11:37 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Limiting CPUs on SUN

Wanted to check on this.
=3D20
Client (Currently 8174) discovered they're only licensed for X CPUs
where they have X+14.  They want to limit this to be in compliance and
still run associated apps.
=3D20
Someone's looking at CPU_COUNT which I don't think really works at
limiting anything.  I've seen it set higher than actual by some DBAs,
but didn't hear what benefit that really was.
=3D20
Sun does have a psrset command I just heard of.   Will that do the job
for
them?
=3D20
    Thanks
    Larry Wolfson
=3D20
=3D20
    We did this on TRU64 but we had to modify the OS ourselves.  Not a
popular decision.
=3D20
=3D20
NAME
psrset - creation and management of processor sets=3D20

SYNOPSIS

psrset -a processor_set_id processor_id...=3D20

psrset -b processor_set_id pid...=3D20

psrset -c [processor_id]...=3D20

psrset -d processor_set_id=3D20

psrset -e processor_set_id command [argument(s)]=3D20

psrset -f processor_set_id=3D20

psrset [-i] [processor_set_id]...=3D20

psrset -n processor_set_id=3D20

psrset -p [processor_id]...=3D20

psrset -q [pid]...=3D20

psrset -r processor_id...=3D20

psrset -u pid...=3D20

DESCRIPTION

The psrset utility controls the management of processor sets. Processor
sets allow the binding of processes to groups of processors, rather than
just a single processor. There are two types of processor sets, those
created by the user using the psrset command or the pset_create(2)
<@FPI2SOI;targetdocent=3D3D-%2F%2FSun%3A%3ASunSoft%2F%2FDOCUMENT+REFMAN2+=
V
e=3D
r
sion
+2.0%2F%2FEN;localinfo=3D3Dpset-create-2;type=3D3D> system call, and =
those
automatically created by the system. Processors assigned to user-created
processor sets will run only LWPs that have been bound to that processor
set, but system processor sets may run other LWPs as well.

System-created processor sets will not always exist on a given machine.
When they exist, they will generally represent particular
characteristics of the underlying machine, such as groups of processors
that can communicate more quickly with each other than with other
processors in the system. These processor sets cannot be modified or
removed, but processes may be bound to them.

l =3D20



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


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