Hi there,
Oracle 8.0.5/ Apps 11.0.3, NT 4.0.
Today, users are getting following errors at random when they execute modules in the application.
ORA-604: Error occurred at recursive SQL 1 Level.
ORA-00018: Maximum number of sessions exceeded.
ORA-01000: Maximum open cursors exceeded.
I checked count(*) from v$session. It was 63 (including background processes)
Foll. are other init.ora parameters.
PROCESSES = 75
SESSION = 87
TRANSACTION = 95
OPEN_CURSORS = 300
SESSION_CAHCHED_CURSORS = 150
SESSION_MAX_OPEN_FILES = 0
It is on Production.
Pl. help...
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart