Routine Query Becomes Terribly Slow Over Time with High PX_MISMATCH.
Last updated on AUGUST 22, 2012
Applies to:Exadata Database Machine V2 - Version Not Applicable and later
Oracle Exadata Hardware - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Exadata Database Machine X2-2 Full Rack - Version Not Applicable and later
Exadata Database Machine X2-2 Half Rack - Version Not Applicable and later
Exadata Database Machine X2-2 Hardware - Version Not Applicable and later
Information in this document applies to any platform.
The following symptoms are seen:
- Exadata X2-2 half rack system running 18.104.22.168
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms