Parallel query ORA-600 /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 220.127.116.11 and later
Information in this document applies to any platform.
Parallel query can encounter the following issue:
1,Fail with ORA-600 .This may be followed by ORA-600 [kxfpSendExitMsg:1]
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
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