Re: Restricting Oracle to one processor
- From: "Mark Brinsmead" <pythianbrinsmead@xxxxxxxxx>
- To: yong321@xxxxxxxxx
- Date: Sun, 8 Jun 2008 21:20:24 -0600
Interesting capability.
However, this does not, to my knowledge, relieve you of the need to license
Oracle for all processors, which is what the OP was trying to do.
On Sun, Jun 8, 2008 at 8:50 PM, Yong Huang <yong321@xxxxxxxxx> wrote:
> While the license issue is equally important, I want to point out that in
>
> "Oracle9i Release 2 Database Architecture on Windows
> An Oracle Technical White Paper
> April 2003"
>
> Oracle does state they support processor affinity:
>
> "Much like the ORACLE_PRIORITY setting, the ORACLE_AFFINITY registry
> setting allows a database administrator to assign the entire Oracle process
> or
> individual threads in that process to particular CPUs or groups of CPUs in
> the
> system."
>
> You can search for "ORACLE_AFFINITY" on tahiti.oracle.com for official
> documentation. The registry setting exists for 9i, 10g and 11g.
>
> Yong Huang
>
> > Is it possible to restrict Oracle to one of the two processors. We would
> > be running Oracle 10gR2 on Windows server 2003. Essentially the desire is
> > to use one processor for Oracle and the other for windows.
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs
Other related posts:
