Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

ORA-00093: pga_aggregate_limit must be between 12288M and 100000G - ODA X7 2S

edited Jan 25, 2019 3:07PM in Oracle Database Appliance (ODA) (MOSC) 4 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center