Can somebody tell me what is cpu_count and how can I find out?
CPU_COUNT specifies the number of CPUs available to Oracle. On single-CPU computers, the value of CPU_COUNT is 1.
This parameter typically is used in the calculateion of the default value of other parameters in various releases, and to decide if 'latch spinning' is appropriate. Eg: It is used to derive a value for .
On most platforms Oracle automatically sets the value of CPU_COUNT to the number of CPUs available to your Oracle instance. Do not change the value of CPU_COUNT unless specifically advised to do so.
If there is heavy contention for redo latches, change the value of
LOG_SIMULTANEOUS_COPIES to twice the number of CPUs you have. Do not change the value of CPU_COUNT.
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
Click Here to Expand Forum to Full Width