50 isn't much, depending on what you are doing. Oracle's CASE tool requires
a much higher value, even with just one user.
If you are worried about held resources, then start to scan the v$ tables to
see what they tell you, users, pinging, etc.
Thor HW
----- Original Message -----
From: "Vdaygiri, Subu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 16, 2000 4:29 PM
Subject: ORA-01000: maximum open cursors exceeded
> To all Oracle & J2EE gurus,
>
> I have using Oracle as database connection for the J2EE server(with
Oracle's
> JDBC thin driver - classes12.zip). I am getting these two errors -
> - ORA-01000: maximum open cursors exceeded
> and sometimes
>
> - exceeding the number of processes allowed i.e 50.
>
> Yes, I could change the OPEN CURSORS or increase the number of processes
for
> Oracle. But I am the only person running applications of this server
(hence
> it can't be THAT overloaded). I was wondering if the J2EE server is
> releasing the Oracle resources like cursors, etc properly or is there
> something in configuration that I can do to prevent the above two errors.
>
> Thanks a lot for the help !!
>
> Subu
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
