Oracle database error code ORA-00827 – could not shrink sga_target to specified value

Oracle Database Error Code ORA-827 Description :
could not shrink sga_target to specified value
Error 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.

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»