ORA-00604, ORA-04031

From: Steve Robin <ocmaman_at_gmail.com>
Date: Mon, 3 Dec 2007 08:53:22 -0800 (PST)
Message-ID: <7c6d30c7-12db-477b-9736-79a718c173d2@j20g2000hsi.googlegroups.com>

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