Routine Query Becomes Terribly Slow Over Time with High PX_MISMATCH.
(Doc ID 1379750.1)
Last updated on MARCH 04, 2019
Applies to:Exadata X3-8 Hardware - Version All Versions and later
Exadata Database Machine V2 - Version All Versions and later
Oracle Exadata Hardware - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Exadata Database Machine X2-2 Full Rack - Version All Versions and later
Exadata Database Machine X2-2 Half Rack - Version All Versions and later
Information in this document applies to any platform.
The following symptoms are seen:
- Exadata X2-2 half rack system running 220.127.116.11
- Two queries running (every 3 to 4 minutes) without problem for about 4 to 6 weeks.
- However, recently the same queries, against the same databases, on the same Compute Nodes are now running with high CPU.
- They normally take well under 30 seconds to run, but are now taking several minutes minimum.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!