Load DWH Job Fails With Error ORA-12801

Products

• Clarity PPM On Premise

Issue/Introduction

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")

Environment

Release : Any

Resolution

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.