<<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
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
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 10G
pga_aggregate_target big integer 5G
SQL> startup
ORACLE instance started.
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>
Fixed Size 12455848 bytes
Variable Size 1.6442E+10 bytes
Database Buffers 704643072 bytes
Redo Buffers 21098496 bytes
Database mounted.
Database opened.
SQL>
Comments
Post a Comment