Home » RDBMS Server » Performance Tuning » ORA-00604: error occurred at recursive SQL level 1 ORA-04031
ORA-00604: error occurred at recursive SQL level 1 ORA-04031 [message #152143] Wed, 21 December 2005 06:50 Go to next message
janeshb
Messages: 3
Registered: December 2005
Junior Member
Some time following error come when we r using oracle 10g + servlet + linux

Error: SQLException java.sql.SQLException: ORA-00604: error occurred at
recursive SQL level 1 ORA-04031: unable to allocate 4216 bytes of shared memory
("shared pool","unknown","sga heap",asdasd)

What is the cause for the above error? If any noe give solution.
Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 [message #152147 is a reply to message #152143] Wed, 21 December 2005 07:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check your SHARED_POOL_SIZE and JAVA_POOL_SIZE.
Either they are inadequate or too high.
Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 [message #152152 is a reply to message #152147] Wed, 21 December 2005 07:12 Go to previous messageGo to next message
janeshb
Messages: 3
Registered: December 2005
Junior Member
Mr.Mahesh,
Thanks for your reply my server status is
Linux Red hat es 64 bit
Oracle 10g
2 GB ram
40 GB HDD
3.0 Dual Processor

My memmory setup is as follow

Automatic Shared Memory Management Enabled

Total SGA Size (MB) 652

SGA Component Current Allocation (MB)
Shared Pool 252
Buffer Cache 220
Large Pool 168
Java Pool 8
Other 4

Maximum SGA Size* (MB) 700 MB

Please guide me is it proper or not?
Janesh
Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 [message #152159 is a reply to message #152152] Wed, 21 December 2005 07:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I cannot comment on the exact settings without understanding a lot about your environment ( your code, your init parameters etc).
The above said error is a very generic one and is ***usually*** because of low SHARED_POOL setting which may result in "out of memory" related errors.
So flushing the shared pool or even just restarting the database ***may*** fix it.
If this is a consistent and reproducible case then
save your current configuration.
Increase shared_pool .
Bounce the database and try again.
search the forum for ORA-04031.
See all the discussions about it. Decide accordingly.

Did you also look into alert_sid.log?
Are any background processes terminated?

[Updated on: Wed, 21 December 2005 07:31]

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 [message #152165 is a reply to message #152159] Wed, 21 December 2005 07:58 Go to previous message
janeshb
Messages: 3
Registered: December 2005
Junior Member
Thanks Mr Manesh
Previous Topic: Finding it impossible to tune this query
Next Topic: Analyzing indexes...
Goto Forum:
  


Current Time: Mon Nov 28 05:56:41 CST 2022