Oracle DBA, How To, Error, Cause and Action

ORA-00846: could not shrink MEMORY_TARGET to specified value

ORA-00846: could not shrink MEMORY_TARGET to specified value


Cause:


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



Action:


Do not set MEMORY_TARGET to a value below the current value without first shrinking the individual memory components.

No comments:

Post a Comment

Thanks for your comment.