Parallel query ORA-600 [15713]/ORA-600 [kxfpSendExitMsg:1]/ORA-600 [kxfpqsod_qc_sod]OR HANG DUE TO ORA-4031 IN LARGE POOL,PX MSG POOL (Doc ID 1537870.1)

Last updated on SEPTEMBER 09, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Parallel query can encounter the following issue:

1,Fail with ORA-600 [15713].This may be followed by ORA-600 [kxfpSendExitMsg:1]
2,ORA-600 [kxfpqsod_qc_sod]
3,ORA-4031: unable to allocate 131096 bytes of shared memory ("large
pool","unknown object","large pool","PX msg pool")

Increasing Large pool may lead to :

ORA-12805: parallel query server died unexpectedly



Cause

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