ORA-00823: Specified value of sga_target greater than
sga_max_size



ORA-00823: Specified value of sga_target greater than sga_max_size..

Answer / guest

Cause: The specified value of sga_target is greater than
sga_max_size.

Action: Increase sga_max_size to match up with sga_target or
decrease sga_target to match up with sga_maxsize.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02807: Allocation of memory for I/O vectors failed.

1 Answers  


RMAN-00562: username too long

1 Answers  


ORA-30657: operation not supported on external organized table

2 Answers  


DRG-10709: this preference is referenced by string and cannot be dropped

1 Answers  


PCC-02353: Semantic error at line number, column number, file string:

1 Answers  


ORA-38413: elementary attribute name may not be longer than 32 characters

1 Answers  


ORA-00110: invalid value string for attribute string, must be between string and string

1 Answers  


DRG-11730: relation does not exist

1 Answers  


RMAN-06028: duplicate operand specified in restore specification: string

1 Answers  


ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB

1 Answers  


KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

1 Answers  


Categories