Home » RDBMS Server » Server Administration » ORA-00604: error occurred at recursive SQL level 3...Please help
- ORA-00604: error occurred at recursive SQL level 3...Please help [message #158009] Wed, 08 February 2006 00:10 Go to next message
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

Report message to a moderator

- 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 Go to previous messageGo to next message
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..

Report message to a moderator

- Re: ORA-00604: error occurred at recursive SQL level 3...Please help [message #158341 is a reply to message #158061] Fri, 10 February 2006 01:28 Go to previous message
gururajan.r
Messages: 3
Registered: January 2006
Location: INDIA
Junior Member


THANKS FOR YOUR KIND SUGGESTIONS..

I INCREASED MY SGA SIZE AND REMOVED ALL THE TRACE FILES...

NOW I CAN ABLE TO LOGIN AND DROP THE USERS

Report message to a moderator

Previous Topic: Ora-27101: Shared Memory Realm Does Not Exist
Next Topic: Rollback segment issue!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 04 00:06:21 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.