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-13829: SQL profile named string already exists

1 Answers  


PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


ORA-31644: unable to position to block number string in dump file "string"

1 Answers  


ORA-10621: data block does not belong to the segment

1 Answers  


ORA-15017: diskgroup "string" cannot be mounted

1 Answers  






ORA-07425: sdpri: error string in translating dump file location.

1 Answers  


ORA-31072: Too many child nodes in XMLType fragment for updateXML

1 Answers  


PLS-00551: character set ANY_CS is only allowed on a subprogram parameter

1 Answers  


DRG-11872: Can't Connect To WAIS Server

1 Answers  


ORA-31479: could not create LogMiner session

1 Answers  


SQL*Loader-00463: secondary data file for LOB is string

1 Answers  


DRG-50901: text query parser syntax error on line string, column string

1 Answers  


Categories