OraFAQ Forum: Performance Tuning » ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded [message #332658]

Wed, 09 July 2008 05:27

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

Report message to a moderator

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

rleishman
Messages: 3728
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

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	SQL Tuning (Multicolumn Range Parttiion Pruning)
Next Topic:	Query running slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 07:38:00 CDT 2024