Oracle DBA, How To, Error, Cause and Action

ORA-00827: could not shrink sga_target to specified value

ORA-00827: could not shrink sga_target to specified value


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.



Action:


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

No comments:

Post a Comment

Thanks for your comment.