Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00604, ORA-04031
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared
pool","select file#, block#, ts# fr...","sga heap(1,0)","kglsim object
batch")
I got these error in oracle 10g, I was not able to investigate the reason, because I was not able to connect with database. I needed to kill process and then restart the database.
I got following line in mmon trc file.
SGA POLICY: Cache below reserve and cant get memory from any other component.
sga_target = 380M
sga_max_size = 380M
Oracle : 10.2.0.2
OS : SunOS 5.9
Please let me know if I cann't find the cause for it, as well solution. Received on Mon Dec 03 2007 - 10:53:22 CST
![]() |
![]() |