aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

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 while pga_aggregate_target is not specified
Action: before setting 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 is needed for the SGA minus what is needed for the operating system (e.g. 500MB)

请先 登录 后评论

1 个回答

小智
ORA-04032:pga_aggregate_target必须在切换到自动模式之前设置,
.原因:尝试在不指定pga_aggregate_target的情况下将workarea_size_policy设置为AUTO,
.操作:在设置workarea_size_policy之前,将pga_aggregate_target设置为表示实例可用的总私有内存的值。这个总量通常是系统中可用的总物理内存减去SGA减去操作系统所需的总内存容量(例如500MB),
.
请先 登录 后评论