Re: Restricting Oracle to one processor

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.
      

--
http://www.freelists.org/webpage/oracle-l