Home > Archive > Oracle Server > May 2005 > is there a way of using a Single processor Oracle License on Multi CPU Box









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author is there a way of using a Single processor Oracle License on Multi CPU Box
jiggaman

2005-05-24, 8:23 pm

we have a single cpu Oracle 8i EE license. We need to migrate the
database to a new box which has 4 cpu's. Is there a way to limit the
usage of oracle 1 cpu so that we are not in violation of our license.
Any help or pointers on this issue will be very helpful.

thanx in advance

Jiggaman

Dave

2005-05-24, 8:23 pm


"jiggaman" <jiggamanrocks@yahoo.com> wrote in message
news:1116975179.468081.77820@g44g2000cwa.googlegroups.com...
> we have a single cpu Oracle 8i EE license. We need to migrate the
> database to a new box which has 4 cpu's. Is there a way to limit the
> usage of oracle 1 cpu so that we are not in violation of our license.
> Any help or pointers on this issue will be very helpful.
>
> thanx in advance
>
> Jiggaman
>


nope, you have to disable / remove the cpu's


jiggaman

2005-05-25, 3:23 am

Hi Guys ,

Thanx for your reply. I am using windows 2000 server, the box is a
dell server with 4 cpu's on board. I dont have the model number of the
Dell box...but i have a gut feeling that windows will not allow to
configure a program to run on 1 dedicated cpu. lets hope i am wrong.
let me have your feedback if any.

thanx,

Jiggaman


Mark Bole wrote:
> Dave wrote:
>
>
> Since you didn't include platform hardware information, it's difficult
> to give a good answer. What little information there is on Oracle's
> site, says that "hard" CPU partitioning meets the licensing
> requirements, while "soft" does not. (for example, simply off-lining a
> processor on a Solaris box using "psradmin" does not reduce the
> licensing requirement).
>
> You almost certainly can't keep all four CPU's on-line and claim that
> somehow only one of them is doing Oracle work.
>
> Let your sales rep be your guide...
>
> -Mark Bole


Geoff Muldoon

2005-05-25, 3:23 am

jiggamanrocks@yahoo.com says...

> Thanx for your reply. I am using windows 2000 server, the box is a
> dell server with 4 cpu's on board. I dont have the model number of the
> Dell box...but i have a gut feeling that windows will not allow to
> configure a program to run on 1 dedicated cpu. lets hope i am wrong.
> let me have your feedback if any.


A possible thought, but taking into account the posting below ..

Ask about what would happen if you run VMWare on the box and install
Oracle on the virtual machine rather than the host. Versions below ESX
will only allow each virtual machine to access a single CPU.

>
>

Billy

2005-05-25, 3:23 am

jiggaman wrote:

> Thanx for your reply. I am using windows 2000 server, the box is a
> dell server with 4 cpu's on board. I dont have the model number of the
> Dell box...but i have a gut feeling that windows will not allow to
> configure a program to run on 1 dedicated cpu. lets hope i am wrong.
> let me have your feedback if any.



Yes you can bind a Windows process to a single CPU (look for setting
the processor affinity mask API call in the Win32 API docs).

No, Oracle does not support processor binding.

Yes, you can do it externally (bind a process to a processor using
another program).

No, this program is not supplied with the Windows installation media.

Yes, it is a bad idea to do processor binding - load balancing and CPU
allocation are best dealt with at kernel level. Doing this at
application level is very much an exception and usually intereferes
more with the kernel than anything else.

Yes, even a process bound to a single CPU can still benefit from
additional CPUs. AND THAT IS THE CRUX OF THE MATTER.

Simply example. Oracle does an overlapped i/o call (Windows talk for
async i/o). That will be happily serviced by the kernel on another CPU,
despite the fact that the Oracle DBWR thread is bound to a single CPU.

--
Billy

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com