Re: Restricting Oracle to one processor

From: Yong Huang <>
Date: Sun, 8 Jun 2008 19:50:52 -0700 (PDT)
Message-ID: <>

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 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.

Received on Sun Jun 08 2008 - 21:50:52 CDT

Original text of this message