Hello
I am using Oracle 18c EXPRESS EDITION (XE) on CentOS 7. The VM has 6GB RAM.
I can sometime see ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT in database logs. I have following parameter settings:
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 4G
pga_aggregate_target big integer 512M
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 1536M
sga_min_size big integer 0
sga_target big integer 1536M
unified_audit_sga_queue_size integer 1048576
As XE allows only 2GB RAM to the database my question is can increasing pga_aggregate_limit fix ORA-04036 error? If not what's the solution other than going for a non-XE version?
Regards,
Habib