ORA-00093: pga_aggregate_limit must be between 12288M and 100000G - ODA X7 2S
Hi
We configured our X7 -2S ODA using the sahpe of using 2 core / 8 GB RAM
Here was the settings
SQL> show parameter sga
sga_max_size big integer 8G
sga_min_size big integer 0
sga_target big integer 8G
unified_audit_sga_queue_size integer 1048576
pga_aggregate_limit big integer 8G
pga_aggregate_target big integer 4G
sga_target big integer 8G
After that, we wanted to increase the SGA a little bit since the system has 192 GB RAM
SQL> alter system set pga_aggregate_target=6G scope=spfile;
System altered.
SQL> alter system set sga_max_size=30G scope=spfile;