| ORA-00604: error occurred at recursive SQL level 3...Please help [message #158009] |
Wed, 08 February 2006 00:10  |
gururajan.r
Messages: 3
Registered: January 2006
Location: INDIA
|
Junior Member |
|
|
Dear All,
I am using oracle 10G , i have come across the following error.
Errors in file e:\oracle\product\10.1.0\admin\orcl\bdump\orcl_cjq0_3472.trc:
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")
Kindly advice how th proceed...
In this case i have increased my Shared pool size from 83M to 92M and initially logged in . After some time i am getting the above error.
Another problem is the drive in which oracle installed is full,no physical O/S memory.
I have attached the trace file for your kind advice.
Kindly make advice and support me from out of this problem
Regards
Gururajan R
|
|
|
|
| Re: ORA-00604: error occurred at recursive SQL level 3...Please help [message #158061 is a reply to message #158009] |
Wed, 08 February 2006 05:31  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
|
Please increase the size of your sga , as the current size is not sufficient to handle the load. That should get the solution to your ora-04031 problem...about the drive where oracle is installed being full, if you have any other non oracle related files you can remove, also you can remove the trace files (under bdump,cdump,udump etc) if they are in that location (place them in some other location), basically try to remove all unnecessary file and see..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
