Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Connection inactive

Oracle Connection inactive

From: Oliver Huppert <Oliver.Huppert_at_pikon.com>
Date: Thu, 25 Apr 2002 17:28:57 +0200
Message-ID: <aa9760$nio$00$1@news.t-online.com>


Hello *.*

I have a problem with connections from JDBC to Oracle. We are using a middleware, that does not support Oracle by itself.

So the problem is that the connections are not closed after processing. When I look on the view v$session the connection are still there, but inactive, because when the browser is closed, the middleware will not close the DB-Connection.

Is there a procedure, that could delete the inactive connection from a specified user and with the timestamp before a specified time.

Thanx
Olli Received on Thu Apr 25 2002 - 10:28:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US