| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why doesn't Oracle kill dead connections?
<font size=2 color=navy
face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>Much of this is controlled through Oracle’s
SQL*Net product. It needs to be
configured. It also depends on
what version of the database you are using.<span style="mso-spacerun:
yes"> Oracle8.0/8i and beyond have mechanisms called profiles
(oracle7 had them as well but didn’t work well) that can assist in dead connection
detection.
<font size=2 color=navy
face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>
<font size=2 color=navy
face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>The problem with Web-based dead connection is that
if the application server retains the connection, the stuff will work.<span
style="mso-spacerun: yes"> However, if the application server has
started the SQL/PL/SQL process and then goes off to do other work, and return
back, the dead connection stuff may disconnect you by accident.
<font size=2 color=navy
face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>
<font size=2 color=navy
face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>Guess it is trial and error.
<font size=2 color=navy
face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>
<!---size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'><span style='mso-element:
field-begin'> AUTOTEXTLIST
\s "E-mail Signature" <span
class=EmailStyle18><i style='mso-bidi-font-style:
normal'><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:"Monotype Corsiva";
color:#3366FF;font-weight:bold;font-style:italic'>Thank You
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<b style='mso-bidi-font-weight:
normal'><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:Tahoma;mso-bidi-font-family:Arial;
color:blue;font-weight:bold'>Stephen P. Karniotis
<font size=2 color=red
face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Technical
Alliance Manager
<font size=2 color=red
face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Compuware
Corporation
<font size=2 color=red
face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Direct:<span
style='mso-tab-count:1'> (248)
865-4350
<font size=2 color=red
face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Mobile:<span
style='mso-tab-count:1'> (248)
408-2918
<font size=2 color=red
face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Email:<span
style='mso-tab-count:1'> <a
href="mailto:Stephen.Karniotis_at_Compuware.com"><span
style='font-size:12.0pt;color:red'>Stephen.Karniotis_at_Compuware.com
<font size=2 color=red
face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Web:<span
style='mso-tab-count:1'> <a
href="http://www.compuware.com/"><span style='font-size:
12.0pt;color:red'>www.compuware.com
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;mso-bidi-font-weight:bold'>
<!---size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'><span style='mso-element:
field-end'><font
size=2 color=navy face="Comic Sans MS"><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'>
<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: Sona
[mailto:sona_us_at_hotmail.com]
Sent: Tuesday, January 15, 2002
7:20 PM
To: Multiple recipients of list
ORACLE-L
Subject: Why doesn't Oracle kill
dead connections?
<span
style='font-size:12.0pt'>
<font size=2 color=black
face=Arial>Hi<font
color=black>
<font size=2 color=black
face=Arial>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.<span style='color:black;
mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>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).<span style='color:
black;mso-color-alt:windowtext'>
<font size=2 color=black
face=Arial>Is
there any way to force Oracle to kill the session when the user closes the
browser?<span style='color:black;mso-color-alt:
windowtext'>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<font size=2 color=black
face=Arial>TIA<font
color=black>
Received on Wed Jan 16 2002 - 09:06:03 CST
 |
 |