SQL> startup
ORA-00371: not enough shared pool memory, should be atleast 410122547 bytes
我的系统是oracle10g solaris10RAC +ASM 架构 内存8g
我刚调了下,SHARED_POOL_SIZE=350m 居然起不来,最少就要400m ,那调优 不是得调到 7~800m我晕了,share pool 怎么要那么大了?
This weekend we upgraded from 8.1.7.4 32-bit to 10.1.0.5 64-bit (AIX 5.2) and we are experiencing a large number of 4031 errors(these were extremely rare under 8).We have contacted Oracle support as a sev 1 issue, but I thought I would drop a note to see if anyone has experienced anything like this while we wait.Under 8 our shared pool was approximately 250m.We initially set the shared pool to 1.2g under 10 and that was not enough.In the interim, we decided to increase the shared pool to 3g to see if we can buy some time while we continue to wait (and that has been successful so far).We do have some literal sql and some opportunities for improvement, but I would think we should experience "somewhat" similar behavior in terms of memory usage with the upgrade vs. the prior version.The amount of memory seems very excessive to me.In addition, we are not using the memory autotuning featur e.Anybody know of a bug related to excessive shared pool usage or any other thoughts?Thanks