Message-ID: <F001.00427499.20020313080346@fatcity.com>
Date: Wed, 13 Mar 2002 08:03:46 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Ji, Richard" <Richard.Ji@MobileSpring.com>
Subject: RE: cursor not closing
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: multipart/mixed;	boundary="----_=_NextPart_001_01C1C75E.94C6E300"
------_=_NextPart_001_01C1C75E.94C6E300
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Identify all the codes where ResultSet, Statement are used and make sure
they are closed after it's done.

-----Original Message-----
Sent: Friday, March 08, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L


Hi,

We have a Application that user JDBC thin client connecting to Oracle
database.
It seems like java code is opening the cursor , running some sql but not
closing
the cusrsor.
Now the number of open_cursor reached 3568 .
Is there any way we can close cursor from sqlplus.

Thanks
--Harvinder
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Harvinder Singh
  INET: Harvinder.Singh@MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Ji, Richard
  INET: Richard.Ji@MobileSpring.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C1C75E.94C6E300
Content-Type: application/ms-tnef;
 name="winmail.dat"
Content-Transfer-Encoding: 7bit

<encoded content removed -- binaries not allowed by ListGuru>

------_=_NextPart_001_01C1C75E.94C6E300--
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster@fatcity.com for clarification.

------_=_NextPart_001_01C1C75E.94C6E300--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ji, Richard
  INET: Richard.Ji@MobileSpring.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).