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 and later
Information in this document applies to any platform.


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


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