开发者

Sort Area Size (KB) - Invalid value for sort area size. The minimum value is: 96 KB

开发者 https://www.devze.com 2023-03-10 08:34 出处:网络
When I try to reorganize a tablespace with OEM 10g, I get an error in the 3rd step (option开发者_如何转开发s) saying : Invalid value for sort area size. The minimum value is 96 KB. My SGA management i

When I try to reorganize a tablespace with OEM 10g, I get an error in the 3rd step (option开发者_如何转开发s) saying : Invalid value for sort area size. The minimum value is 96 KB. My SGA management is set to AUTO. Why this error on sort size area ? Thanks for your help.

workarea_size_policy AUTO
pga_aggregate_target 8192 MB
large_pool_size 16777216 B
sort_area_size  65536


It is recommeneded to leave this parameter out. You are using AUTO and defined a very large PGA, let Oracle do it's magic!

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号