I´m begginer with Oracle and I will install Oracle9i in a server with 4 processor Xeon 2.2 HT , but I would like to determine the processor that I will use. For example, I would like to use only processor 3 and 4 . Can someone learn me how to do it ?
05-05-2006, 08:21 AM
you cant (unless you disable the other cpus at the os level)
05-05-2006, 01:43 PM
I was searching about Control Processor and I found a parameter called "Oracle_affinity" that can be configured on register (Regedit). We can reserve a CPU to execute especific threads. We can to isolate the CPU´s that will be used by Oracle if we determine all thread associeted with CPU´s.
Whether someone used this parameter , can you explain how to use it ?
05-05-2006, 01:59 PM
Thats on 10g Release 2 (you are on 9i)
05-05-2006, 04:27 PM
I saw about oracle_affinity with Oracle9 for Windows
Configuration Parameters and the Registry - This chapter describes use of the registry for various Oracle9i for Windows ... ORACLE_AFFINITY. Specifies Windows NT processor affinity of each thread ... www.stanford.edu/dept/itss/ docs/oracle/9i/win.920/a95490/registry.htm
Can some one help me how can I configure this parameter in regedit ?
05-05-2006, 05:09 PM
right them, im talking a load of crapola. But that only seems to take effect for the background processes, any user processes will still use ANY cpu as I read that
05-05-2006, 05:13 PM
What difference does it make if it uses 2 cpu's more intensly or 4 less, it is the same sh*t with a different stink.
05-08-2006, 07:34 AM
The Server is a HP560 with 2 CPU 2.2 HT and 8 Gb RAM. In that Server is running 4 instances SQLServer 2000 . I need create 2 small Oracle 9i instances and I intend install more 2 processor and 2 GB RAM in that server to support a new demand, but I wouldn´t like that new applications intervenes with a old installation.
In SQLServer I can restrict to use only old processors (1-2) easily and I would like to restrict Oracle to use only processors (3-4) .
I am inexperienced with Oracle, but I thought that the Oracle makes everything that the SQLServer makes and plus some things. Then,last friday ,I searched during all day by Oracle' functions.
Can you understand me why I started a question ?
05-08-2006, 08:05 AM
well overall, in Oracle you can't do what you want - you can only control the background processes, not the user processes (which actually do the work)
05-08-2006, 08:50 AM
I will not to give up yet, but I want to thank for your help.