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 220.127.116.11 to 18.104.22.168 [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 22.214.171.124
- 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms