我的oracle 10g出问题了,登录时弹出如下错误,望兄弟们能帮我下。
错误代码如下:
ora-00604:error occurred at recursive SQL level 3
ORA-04031:unable to allocate 4096 bytes of shared memory ("shared pool","select /*+rule*/bucket_cn..","typecheck heap",kgghteInit")
ORA-00604:error occured at recursive SQL level 2
ORA-04031:unable to allocate 4096 bytes of shared memory ("shared pool","select /*+rule*/bucket_cn...',Typecheck heap","kgghteInit")
错误代码如下:
ora-00604:error occurred at recursive SQL level 3
ORA-04031:unable to allocate 4096 bytes of shared memory ("shared pool","select /*+rule*/bucket_cn..","typecheck heap",kgghteInit")
ORA-00604:error occured at recursive SQL level 2
ORA-04031:unable to allocate 4096 bytes of shared memory ("shared pool","select /*+rule*/bucket_cn...',Typecheck heap","kgghteInit")
shared_pool_size
2 alter system set shared_pool_size=50M ;
ora-04031errror:unable to allocate 4096 bytes of shared memory("shred pool","select f.file#,f.block#,f...","Typecheck heap","kgghteInit")ora-00604:error occurred at recursive SQL level 1郁闷啊,谢谢大家啊,谁有时间可以远程控制下帮我弄弄啊,谢谢兄弟们!!!!!!!!!!
1shutdown abort,
2startup nomount
3 alter system set shared_pool_size=50M ;
尝指定小点的 shared_pool 20M