We recently began using the Oracle Database 12c with PPM. When we run the Datamart Extraction Job, it fails with this series of error message
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_PRTF_SP:
ORA-20000: Error in NBI_EXTR_PRTF_SP - Analyzing NBI_PRT_FACTS: ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 375
The job didn't fail with that type of error message prior to upgrading our database implementation. How can we resolve it?