Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

Cause: The specified value of sga_target 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_target 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 ?    1 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14522: Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


NNO-00111: line string: data type "string" has syntax "string", should be "string", data ignored

1 Answers  


RMAN-10003: unable to connect to target database

1 Answers  


ORA-22976: incorrect number of arguments to MAKE_REF

1 Answers  


ORA-39093: FLASHBACK automatically enabled to preserve database integrity.

1 Answers  






NZE-29194: no CRL found in cache

1 Answers  


ORA-13192: failed to read number of element rows

1 Answers  


ORA-15011: failure group "string" contains no members

1 Answers  


PLS-00250: Incorrect Usage of string in parameters clause.

1 Answers  


ORA-22998: CLOB or NCLOB in multibyte character set not supported

1 Answers  


TNS-04072: Unable to suspend atleast one of the gateways.

1 Answers  


DRG-10314: logging has not been started

1 Answers  






Categories