Select Query With Parallel Other Than 1 Is Hanging And Consuming All CPU in 12.2 And 18c
(Doc ID 2572473.1)
Last updated on AUGUST 08, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Platform : HP-UX Itanium
Table size is approx 1 GB. DOP set to 2 at table and index level.
Select query against the table is hanging without completion and consuming all CPU.
The query is hanging with any DOP like 2,4,6..etc .
Query will run fine in serial mode.i.e without parallelism.
Database upgrade from 12.1 to 12.2.
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