Home » RDBMS Server » Performance Tuning » ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded (Linux 2.6.9-5.ELsmp x86_64 x86_64 x86_64 GNU/Linux)
ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332658] Wed, 09 July 2008 05:27 Go to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Hey,

i am facing an issue while taking trace.
i am working on linux server with oracle 10.2.0.1.0 installed on it.

Whenever i try and take the trace of a service i get the error

Errors in file /home1/oracle10g/product/10.2.0/db_2/admin/qtz10g/udump/qtz10g_ora_7213.trc:
ORA-00604: error occurred at recursive SQL level 51
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 51
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 50
ORA-00036: maximum number of recursive SQL levels (50) exceeded

Can anyone please help me in solving this issue
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332834 is a reply to message #332658] Wed, 09 July 2008 22:31 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Wow. That's a lot of recursion.

Do you have any PL/SQL Functions that run SQL that use different PL/SQL Functions that call more SQL that contain more PL/SQL Functions, etc.

If so, don't do that.

Ross Leishman
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332844 is a reply to message #332658] Wed, 09 July 2008 23:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It smells a loop in the calls or infinite recursion calls, explicit or not (like triggers).

Regards
Michel
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332851 is a reply to message #332658] Wed, 09 July 2008 23:34 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Hey...

Dear Ross Leishman / Michel

this issue that i am facing comes only when i use oracle 10.2.0.1 installed on a linux machine..

whenever i use the same service on a a 9i database..there is no such error..


Is there someting linux specific that interferes with this trace.

Another thing..

the service which i ma trying to trace runs smoothly otherwise..but the oment i trace it ..the service hangs up..

and yet again the database is 10.2.0.1 hosted on linux 2.6.9-5.ELsmp x86_64 x86_64 x86_64 GNU/Linux
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332859 is a reply to message #332851] Wed, 09 July 2008 23:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We don't have your trace and environment, it is hard to diagnose something.

Regards
Michel
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332862 is a reply to message #332658] Wed, 09 July 2008 23:51 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Dear Michel,

thank you a ton for your help...

however i will need ore of your wisdom as this is an issue i need to reolve asap..

the issue is that the trace works well on 9i while it screws on 10g....

infact the trace works well on a 9i oracle ( hosted on SunOS )
10.1 hosted on HP..

but it goes haywire on 10.2 hosted on Linux..



Please help

Please

Kind regards
Ashish
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332864 is a reply to message #332862] Wed, 09 July 2008 23:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 10 July 2008 06:43
We don't have your trace and environment, it is hard to diagnose something.


9i <> 10.1 <> 10.2
Without more information can't say nothing more.

Regards
Michel
Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #333025 is a reply to message #332862] Thu, 10 July 2008 05:54 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If it's urgent, you need to get in touch with Oracle Support.
Previous Topic: SQL Tuning (Multicolumn Range Parttiion Pruning)
Next Topic: Query running slow
Goto Forum:
  


Current Time: Wed Dec 07 16:23:28 CST 2016

Total time taken to generate the page: 0.31160 seconds