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 188.8.131.52 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)
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.
Upgrade of the database from 10gR1 to 11gR2.
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