Load DWH Job Fails With Error ORA-12801
search cancel

Load DWH Job Fails With Error ORA-12801


Article ID: 269133


Updated On:


Clarity PPM On Premise


The Load DWH Job has been failing suddenly with following error in the BG DWH logs:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-12801: error signaled in parallel query server P012
ORA-06512: at "SYS.DBMS_STATS", line 40799
ORA-06512: at "SYS.DBMS_STATS", line 40083
ORA-06512: at "SYS.DBMS_STATS", line 30030
ORA-06512: at "SYS.DBMS_STATS", line 30007
ORA-06512: at "SYS.DBMS_STATS", line 28278
ORA-06512: at "SYS.DBMS_STATS", line 27289
ORA-12853: insufficient memory for PX buffers: current 96576K, max needed 7990224K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")


Release : Any


According to the logs, there is insufficient memory allocation.

The DBA team will need to review the parallel_max_servers parameter and check whether the current value needs to determine
if that value needs to be decreased or increased.