All Oracle Error CodesOracle DBA Forum


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.
1.Reducing sga_target in 10gR2 without getting OR...1