CPU_COUNT

Property	Description
Parameter type	Integer
Default value	Set automatically by Oracle
Modifiable	ALTER SYSTEM Oracle strongly recommends that you do not alter the value of this parameter. If it is necessary to do so, please refer to your operating system-specific documentation for further information.
Range of values	0 to unlimited
Basic	No

Caution:

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.

CPU_COUNT specifies the number of CPUs available to Oracle. On single-CPU computers, the value of CPU_COUNT is 1.

Note:

1. Related: LOG_SIMULTANEOUS_COPIES, SPIN_COUNT

This parameter typically is used in the calculation 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 LOG_SIMULTANEOUS_COPIES.

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.

See view X$KVII for information on the number of CPU's Oracle thinks you are using.

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘CPU_COUNT’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
cpu_count	16	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	number of CPUs for this instance

Oracle initializatoin parameters