| ORA-00604: error occurred at recursive SQL level 1 ORA-04031 [message #152143] |
Wed, 21 December 2005 06:50  |
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 #152152 is a reply to message #152147] |
Wed, 21 December 2005 07:12  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
