could not shrink MEMORY_TARGET to specified value

Solution ID:ORA-00846

Type: Oracle

Cause

Attempted to shrink MEMORY_TARGET to the specified value but did not succeed because the PGA and SGA components could not be shrunk.

Actions

Do not set MEMORY_TARGET to a value below the current value without first shrinking the individual memory 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/10539829


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


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


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


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