Home » RDBMS Server » Performance Tuning » ORA-00604: error occurred at recursive SQL level x (Oracle 10.1.2.0 Windows 2003)
ORA-00604: error occurred at recursive SQL level x [message #396952] Wed, 08 April 2009 08:34 Go to next message
rakesh.c.purohit
Messages: 3
Registered: September 2008
Location: New Delhi
Junior Member

Hi all,

I am using Oracle 10g version 10.1.2.0 on windows 2003 server

We are in Application testing phase

The moment we started making load on our database we use to get two errors, viz...
ORA-00604: error occurred at recursive SQL level x
and .Net framework error.
Sometimes I also get the error connected sessions exeeds its maximum limit.

I have increased my SGA size and Large pool size.
teh maximum process = 500
server is in shared srver mode with
shared servers=5
discripters = 5
buffer cache size is comparatively low

please help
Rakesh Purohit
New Delhi
India

Re: ORA-00604: error occurred at recursive SQL level x [message #396957 is a reply to message #396952] Wed, 08 April 2009 08:47 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
do not explain error.
copy and post the message.
Previous Topic: v$session output
Next Topic: SQL Tuning Help
Goto Forum:
  


Current Time: Thu Dec 08 22:08:17 CST 2016

Total time taken to generate the page: 0.08543 seconds