My Oracle Support Banner

All About the Initialization Parameter CPU_COUNT and Related Issues (Doc ID 2673212.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Purpose

All About the Initialization Parameter CPU_COUNT and Related Issues

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1.  How to set CPU_COUNT?
 2. Guidelines for setting CPU_COUNT
 3. Related Parameter
 4. Common Issues related to CPU_COUNT
 a. Log File Parallel Writes Take Longer with a Higher CPU Count
 b. V$SQL_MONITOR View Does not Return Rows When CPU_COUNT=1024
 c. ORA-04031 Errors in the Shared Pool When Setting CPU_COUNT to a High Value on Exadata Systems
 d. CPU_COUNT Causes ORA-00068
 e. 12c RAC DDL Performance Issue: High "enq: IV - contention" etc if CPU Count is Different
 f. AWR Snapshots And Top Activity In OEM 12c Are Not Working after Changing CPU Count
 g. High "gc cr grant 2-way" / "gc current block 2-way" Wait due to Different CPU Count on Cluster Nodes
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.