标题: ORA-04032: pga_aggregate_target must be set before switching to auto mode [打印本页] 作者: admin 时间: 2016-7-25 11:55 标题: ORA-04032: pga_aggregate_target must be set before switching to auto mode ORA-04032:pga_aggregate_target must be set before switching to auto mode Cause: attempt to set workarea_size_policy to AUTO whilepga_aggregate_target
is not specified Action: beforesetting workarea_size_policy, set pga_aggregate_target to a value
representing the total private memory available to the instance. This total is
generally the total physical memory available in the system minus what isneeded
for the SGA minus what is needed for the operating system (e.g. 500MB)