设置参数: WORKAREA_SIZE _POLICY = AUTO 删除参数:SORT_AREA_SIZE、SORT_AREA_RETAINED_SIZE and HASH_AREA_SIZE 也就是不设置这三个参数,试试
谢谢!机器的内存为512M,现设置如下,但问题依旧。 #large_pool_size=10485760 #large_pool_size=52428800 #shared_pool_size=63553536 shared_pool_size=104857600 #hash_area_size=104857600 #Java_pool_size = 52428800 if not use java9i is use spfile.ora
ava_pool_size = 35M
java_pool_size=52428800
#large_pool_size=10485760
large_pool_size=52428800
#shared_pool_size=63553536
shared_pool_size=104857600
hash_area_size=104857600
ava_pool_size = 52428800
明天继续...
WORKAREA_SIZE _POLICY = AUTO
删除参数:SORT_AREA_SIZE、SORT_AREA_RETAINED_SIZE and HASH_AREA_SIZE 也就是不设置这三个参数,试试
#large_pool_size=10485760
#large_pool_size=52428800
#shared_pool_size=63553536
shared_pool_size=104857600
#hash_area_size=104857600
#Java_pool_size = 52428800 if not use java9i is use spfile.ora