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-02730: osnrnf: cannot find user logon directory

1 Answers  


ORA-21600: path expression too long

1 Answers  


ORA-02304: invalid object identifier literal

1 Answers  


DRG-13004: language is invalid

1 Answers  


ORA-13192: failed to read number of element rows

1 Answers  






ORA-04034: unable to shrink pool to specified size

1 Answers  


ORA-16718: failed to locate the database resource

1 Answers  


LRM-00107: parameter name abbreviation 'string' is not unique

1 Answers  


ORA-14301: table-level attributes must be specified before partition-level attributes

1 Answers  


ORA-38446: Error with embedded ADT "string" in the attribute set.

1 Answers  


KUP-02000: wrong message file version (msg number not found)

1 Answers  


LSX-00010: extra element(s) at end of "~S"

1 Answers  


Categories