My Oracle Support Banner

Intermittent Hang and High CPU With Parallel Execution on Solaris (Doc ID 1363601.1)

Last updated on AUGUST 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Solaris on SPARC (64-bit)

Symptoms

 

Note:  This issue is specific to the Solaris operating system.

 
High CPU and intermittent hangs during parallel execution were seen on a server running Solaris.   The top 5 timed events on an AWR showed "CPU + wait for CPU."

Monitoring the parallel query showed all workers but one in an idle wait.   A single worker showed "NOT WAIT." 


The fact that the truss broke the hang loose and let the parallel execution complete was a major clue that this was an OS-related issue.

Changes

Upgrade of the database from 10gR1 to 11gR2.

Cause

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
Symptoms
Changes
Cause
Solution
References


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