ORA-00820: Specified value of sga_max_size is too small,
needs to be at least stringM



ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM..

Answer / guest

Cause: The specified value of sga_max_size is too small for
the SGA to accommodate all of the necessary SGA components
such as the log buffer, buffer pools, shared pool, etc.

Action: Set sga_max_size to the recommended value or reduce
the values of any SGA component size parameters you have
specified.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  


ORA-01373: insufficient memory for staging persistent LogMiner session

1 Answers  


PCC-02151: Line number column number file string:

1 Answers  


SQL*Loader-00822: operation not supported on external organized table

1 Answers  






PCC-02416: The Object in an OBJECT GET or SET must not be an array

1 Answers  


LSX-00271: invalid character "~c" in hex-encoded binary

1 Answers  


ORA-13519: Database id (string) exists in the workload repository

1 Answers  


ORA-03209: DBMS_ADMIN_PACKAGE invalid file/block specification

1 Answers  


ORA-01603: illegal grouping size in clause "string" of string

1 Answers  


ORA-10615: Invalid tablespace type for temporary tablespace

1 Answers  


ORA-06517: PL/SQL: Probe error - string

1 Answers  


Categories