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

ORA-00283: recovery session canceled due to errors

1 Answers  


ORA-13417: null or invalid layerNumber for get functions

1 Answers  


ORA-01914: invalid auditing option for sequence numbers

1 Answers  


ORA-16039: RFS request version mismatch

1 Answers  


ORA-29928: duplicate default selectivity specified

1 Answers  






TNS-00115: Could not allocate pump global buffers

1 Answers  


ORA-23423: job number string is not positive

1 Answers  


TNS-00527: Protocol Adapter not loadable

1 Answers  


IMG-00834: merged area queue is full

1 Answers  


ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

1 Answers  


TNS-12519: TNS:no appropriate service handler found

1 Answers  


ORA-00373: online log version string incompatible with ORACLE version string

1 Answers  


Categories