Specified value of sga_target greater than sga_max_size

Solution ID:ORA-00823

Type: Oracle

Cause

The specified value of sga_target is greater than sga_max_size.

Actions

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

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


https://community.oracle.com/message/9635352


https://community.oracle.com/message/1578845


https://community.oracle.com/message/3683675


https://community.oracle.com/message/10560517


https://community.oracle.com/message/3724439


https://community.oracle.com/message/1100646


https://community.oracle.com/message/3680819


https://community.oracle.com/message/9269586


https://community.oracle.com/message/4311734


https://community.oracle.com/message/2754297


https://community.oracle.com/message/1700911


https://community.oracle.com/message/4551958


Browse all solutions to database errors from Oracle, MS SQL, or MySQL