ORA-00604: error occurred at recursive SQL level x [message #396952] |
Wed, 08 April 2009 08:34 |
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
|
|
|
|