ORA-00093: pga_aggregate_limit must be between 10240M and 100000G

<<Back to DB Administration Main Page

ORA-00093: pga_aggregate_limit must be between 10240M and 100000G

SQL> startup
ORA-00093: pga_aggregate_limit must be between 10240M and 100000G
ORA-01078: failure in processing system parameters
SQL> Disconnected

Cause: pga_aggregate_limit  is less than double of pga_aggregate_target. Starting from oracle 18c pga_aggregate_limit must be twice or more than twice than pga_aggregate_target 

Solution: set  pga_aggregate_limit twice or more the value of pga_aggregate_target.

example

SQL> show parameter pga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit                  big integer 10G
pga_aggregate_target                 big integer 5G

SQL> startup
ORACLE instance started.

Total System Global Area 1.7180E+10 bytes
Fixed Size                 12455848 bytes
Variable Size            1.6442E+10 bytes
Database Buffers          704643072 bytes
Redo Buffers               21098496 bytes
Database mounted.
Database opened.
SQL>