Parallel Query hangs due to "PX Deq: Join ACK" on RAC
(Doc ID 2223443.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata 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
Microsoft Windows x64 (64-bit)
Parallel Query may not complete, and Query Cordinator(QC) process waits for "PX Deq: Join ACK" when following all conditions are met.
- RAC env on Windows 2012R2
- Interconnect of RAC is configured by Teaming of Windows and Active-Active
- Windows Update program KB：3137691 is not applied
And following messages appear in event log of MsLbfoProvider when this problem happens.
NONE Failing NBL send on TeamNic 0xffffe0014dbd6010
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