could not shrink sga_target to specified value

Solution ID:ORA-00827

Type: Oracle

Cause

Attempted to shrink the SGA to the specified value but did not succeed because the SGA components could not be shrunk as they were already at their minimum sizes.

Actions

Do not set sga_target to a value below the current value without first shrinking the individual SGA components.

Try the following links for this error:


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


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


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


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


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


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


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