标题: ORA-00839: SGA_TARGET cannot be modified to the specified value [打印本页] 作者: admin 时间: 2016-7-10 14:19 标题: ORA-00839: SGA_TARGET cannot be modified to the specified value ORA-00839: SGA_TARGET cannot be modified to the specified value Cause: The specified value of SGA_TARGET was not compatible with current
settings of PGA_AGGREGATE_TARGET and MEMORY_TARGET/MEMORY_
MAX_TARGET. Action: Set SGA_TARGET to be no more than the difference of MEMORY_
TARGET/MEMORY_MAX_TARGET and PGA_AGGREGATE_TARGET. Also
ensure that the current PGA memory used for non-auto workareas is low.