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

PLS-00414: no column 'string' in table

1 Answers  


PLS-00552: flexible character set is not allowed on component element

1 Answers  


ORA-25114: invalid file number specified in the DUMP DATAFILE/TEMPFILE command

1 Answers  


ORA-12729: invalid character class in regular expression

1 Answers  


ORA-14030: non-existent partitioning column in CREATE TABLE statement

1 Answers  






PCC-00124: COMMON_NAME option is specified too late

1 Answers  


ORA-32007: internal

1 Answers  


ORA-31478: could not detach LogMiner session after change set advance

1 Answers  


ORA-39087: directory name string is invalid

2 Answers  


NNL-00577: list_domains: list authoritative domains in the region or subtree

1 Answers  


QSM-02102: mv FROM list references an object in the SYS schema

1 Answers  


KUP-04085: duplicate directory object string and file string specified for unload

1 Answers  


Categories