My Oracle Support Banner

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 MARCH 10, 2020

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.