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.