Home » Other » General » Can I separate CPU for more than one databases on the same BOX ? (Oracle database 10.2.0.3.0)
Can I separate CPU for more than one databases on the same BOX ? [message #405994] Mon, 01 June 2009 08:11 Go to next message
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 #406002 is a reply to message #405994] Mon, 01 June 2009 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I just want to know Is there any way to separate CPU count for databases that running on the same machine?

Quote:
Number Of Processors: 1

What exactly do you want to separate?

Regards
Michel
Re: Can I separate CPU for more than one databases on the same BOX ? [message #406005 is a reply to message #406002] Mon, 01 June 2009 09:34 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
I am sorry about wrong value . Actually The Value is 4.it has 4 processors.

I wanna separate it 2 for development database and 2 for test database on the same box.
Re: Can I separate CPU for more than one databases on the same BOX ? [message #406009 is a reply to message #406005] Mon, 01 June 2009 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to use an OS tool to partition the cpu and starts each Oracle instance in a partition.
How to partition your cpus and use it is an OS question and should be asked in the appropriate forum (not here).

Regards
Michel
Re: Can I separate CPU for more than one databases on the same BOX ? [message #406030 is a reply to message #406009] Mon, 01 June 2009 15:09 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
I know very well Which forum is using for what.
I just wanna sure Oracle database parameters can do it or not.
Thank you michel for your help.
Re: Can I separate CPU for more than one databases on the same BOX ? [message #406054 is a reply to message #406030] Mon, 01 June 2009 23:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle gets its cpu_count parameter value from OS ("sysconf (_SC_NPROCESSORS_ONLN").
Forcing this parameter is not supported by Oracle (stated in Metalink note), more it does not prevent Oracle from using some cpu just misleads it on the real cpu number.

Regards
Michel
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 Go to previous messageGo to next message
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.
Re: Can I separate CPU for more than one databases on the same BOX ? [message #414054 is a reply to message #405994] Mon, 20 July 2009 04:03 Go to previous message
Millim
Messages: 2
Registered: July 2009
Location: Dublin
Junior Member
Hi,

You could use Oracle VM to partition your server if you want to really separate them www.oracle.com/virtualization

or you could make make use of Oracle's Resource Manager:
www.mcs.csueastbay.edu/support/oracle/doc/10.2/server.102/b14231/dbrm.htm

M
Previous Topic: could you please help me
Next Topic: How to convert a RTF document into PDF format?
Goto Forum:
  


Current Time: Thu Mar 28 16:29:53 CDT 2024