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-26029: index string.string partition string initially in unusable state

0 Answers  


PLS-00369: no choices may appear with choice OTHERS in an exception handler

1 Answers  


RMAN-00575: timeout while trying to write to dbms_pipe

1 Answers  


ORA-19505: failed to identify file "string"

1 Answers  


RMAN-12000: execution layer initialization failed

1 Answers  






NZE-29243: the toolkit does not recognize the type of key being used

1 Answers  


RMAN-06405: database closed

1 Answers  


ORA-19011: Character string buffer too small

1 Answers  


ORA-30194: reserved for future use

1 Answers  


QSM-01025: materialized view, string, not found

1 Answers  


ORA-00112: value of string is null

1 Answers  


ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 Answers  


Categories