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

RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

1 Answers  


TNS-04005: Unable to resolve address for string.

1 Answers  


ORA-24265: Insufficient privileges for SQL profile operation

1 Answers  


ORA-24002: QUEUE_TABLE string does not exist

1 Answers  


ORA-00822: MMAN process terminated with error

1 Answers  






ORA-00405: compatibility type "string"

1 Answers  


NNO-00070: administrative region has changed, reloading domain data

1 Answers  


ORA-03206: maximum file size of (string) blocks in AUTOEXTEND clause is out of range

2 Answers  


ORA-00486: ASMB process terminated with error

1 Answers  


PLS-01402: Use of quoted identifier

1 Answers  


ORA-12083: must use DROP MATERIALIZED VIEW to drop "string"."string"

1 Answers  


ORA-40211: algorithm name string is invalid

1 Answers  


Categories