CPU_COUNT specifies the number of CPUs core (processor) available for Oracle Database to use.
CPU count is an automatically derived parameter by the Oracle system and is used to determine:
Various components of Oracle Database are configured based on the number of CPUs, such as:
When Resource Manager is enabled, setting CPU_COUNT limits the CPU utilization to approximately CPU_COUNT processors.
gerardnico@gorcl>show parameter CPU_COUNT
NAME TYPE VALUE
------------------------------------ ----------- ----------
cpu_count integer 8