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

Home -> Community -> Mailing Lists -> Oracle-L -> Why doesn't Oracle kill dead connections?

Why doesn't Oracle kill dead connections?

From: Sona <sona_us_at_hotmail.com>
Date: Tue, 15 Jan 2002 16:36:43 -0800
Message-ID: <F001.003F0D2C.20020115162027@fatcity.com>

Hi
I have a Reporting appliaction. The reports are run from the browser . The reports are basically Pl/SQL packages .the request is made from the browser and then communicated to the database thru  OAS .(oracle application server) which acts as web server. The problem is when a user executes a report (i.e. hits the RUN button) and then closes the broser before the execution of the report is completed.Oracle still contimues running the query in the database. The session still remains ACTIVE in the database even though the client has closed the connection (i.e. the user has closed the browser). Is there any way to force Oracle to kill the session when the user closes the browser?  
TIA Received on Tue Jan 15 2002 - 18:36:43 CST

Original text of this message

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