Hi Kalana,
If you have this error in IFS internal environments,
Set PGA_AGGREGATE_LIMIT to 0 , which removes the limit on PGA usage per session ( then parameter will not have any impact.).
alter system set pga_aggregate_limit=0 scope=both;
more information available here
https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1
I’m not an expert in this area, but with reference to LCS cases G1792550,G2003622) , I found below information.
“IFS do not recommend any value for PGA_AGGREGATE_LIMIT. Oracle introduced it in later versions. so, as I mentioned, Please make it to 0 so that it will only use PGA_AGGREGATE_TARGET. then you will only need to increase PGA_AGGREGATE_TARGET depending on your client-server connection is.”
Also you can refer below article as well.
https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/oracle-12c-apps9-memory-management-amm-or-not-7175
hope this will help.