Can I separate CPU for more than one databases on the same BOX ? [message #405994] |
Mon, 01 June 2009 08:11 |
dba4bank
Messages: 49 Registered: October 2007 Location: TURKEY
|
Member |
|
|
Hi All,
I just want to know Is there any way to separate CPU count for databases that running on the same machine?
P.S= We are looking this issue for the test environment not for production.
Database version=
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio
NLSRTL Version 10.2.0.3.0 - Production
OS Detail=
System Model: IBM,9116-561
Machine Serial Number: 0623C30
Processor Type: PowerPC_POWER5
Processor Implementation Mode: POWER 5
Processor Version: PV_5_3
Number Of Processors: 1
Processor Clock Speed: 1798 MHz
CPU Type: 64-bit
|
|
|
|
|
|
|
|
Re: Can I separate CPU for more than one databases on the same BOX ? [message #406190 is a reply to message #406054] |
Tue, 02 June 2009 14:12 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Different OS have different ways to limit resources (most commonly CPU) available to certain s/w, users or whatever.
Sometimes the objective is to ensure that the s/w, user or whatever can never exceed a certain number of cores even if the other cores are idle. This is commonly used to meet s/w licensing terms.
Other times you want to garantee a min amount of resource is always reserved for some s/w, user or whatever, while allowing any idle resource to be available for use too if it's idle. This would allow you to make best use of the avialible CPU while garanteeing that neither oracle instance can hog it all at the expense of the other.
|
|
|
|