But in my case if DCD is set up and the browser is closed will the web server know that the connection has been closed and will it tell Oracle to kill the session?
TIA ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 3:20 PM > DCD was invented and implemented for 7.1 of Oracle because of the > strange and wonderful handling of timeout stuff in Unix. Typically, it > can take between 8 and 80 hours for Unix to discover that a session > should be killed since it no longer has a connection to the Oracle > database. The problem is this: > > Sometimes it works. Sometimes it doesn't. > > There can be many reasons for a packet not to return. > > Back to Life: But DCD works by sending this special, empty packet, every > n minutes. If the packet comes back with an error attached, the > connection will be terminated. If it doesn't it's assumed that the > connection is alive and kicking. > > Mogens > > > [EMAIL PROTECTED] wrote: > > >Question 1 is how long does the report take to run? If you have DCD set up with > >a time-out of 1 second your network is going to take a heck of a hit just from > >probe packets. The most common setting I've run into is 15 to 30 minutes so > >that does not help. Setting up a profile for the Internet user that allocates a > >max cpu can likewise be nasty in that the time allocation may not be large > >enough for the report to run. This can get especially frustrating as the amount > >of data that the report must process grows. The last point is that I do not > >believe DCD works with sessions that are ACTIVE since the client side (yes the > >OAS server is a client) is waiting for the database and not responding to > >anything else. I believe it only works with INACTIVE sessions which is not your > >problem. The other point is that the WEB is a stateless world where even the > >web server may not be cognizant of the client closing his/her browser. Do you > >have the same problem if the client hits the STOP button? > > > >Dick Goulet > > > >____________________Reply Separator____________________ > >Author: "Karniotis; Stephen" <[EMAIL PROTECTED]> > >Date: 1/16/2002 6:15 AM > > > >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. > >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. > > > >The problem with Web-based dead connection is that if the application server > >retains the connection, the stuff will work. 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. > > > >Guess it is trial and error. > > > >Thank You > > > >Stephen P. Karniotis > >Technical Alliance Manager > >Compuware Corporation > >Direct: (248) 865-4350 > >Mobile: (248) 408-2918 > >Email: <mailto:[EMAIL PROTECTED]> > >[EMAIL PROTECTED] > >Web: <http://www.compuware.com/> www.compuware.com > > > > > >-----Original Message----- > >Sent: Tuesday, January 15, 2002 7:20 PM > >To: Multiple recipients of list ORACLE-L > > > >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 > > > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > ><html xmlns:v="urn:schemas-microsoft-com:vml" > >xmlns:o="urn:schemas-microsoft-com:office:office" > >xmlns:w="urn:schemas-microsoft-com:office:word" > >xmlns="http://www.w3.org/TR/REC-html40";> > > > ><head> > ><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > > > > > ><meta name=ProgId content=Word.Document> > ><meta name=Generator content="Microsoft Word 9"> > ><meta name=Originator content="Microsoft Word 9"> > ><link rel=File-List href="cid:[EMAIL PROTECTED]";> > ><!--[if gte mso 9]><xml> > > <o:OfficeDocumentSettings> > > <o:DoNotRelyOnCSS/> > > </o:OfficeDocumentSettings> > ></xml><![endif]--><!--[if gte mso 9]><xml> > > <w:WordDocument> > > <w:Zoom>0</w:Zoom> > > <w:DocumentKind>DocumentEmail</w:DocumentKind> > > <w:EnvelopeVis/> > > </w:WordDocument> > ></xml><![endif]--> > ><style> > ><!-- > > /* Font Definitions */ > >@font-face > > {font-family:"Comic Sans MS"; > > panose-1:3 15 7 2 3 3 2 2 2 4; > > mso-font-charset:0; > > mso-generic-font-family:script; > > mso-font-pitch:variable; > > mso-font-signature:647 0 0 0 159 0;} > >@font-face > > {font-family:Garamond; > > panose-1:2 2 4 4 3 3 1 1 8 3; > > mso-font-charset:0; > > mso-generic-font-family:roman; > > mso-font-pitch:variable; > > mso-font-signature:647 0 0 0 159 0;} > >@font-face > > {font-family:"Monotype Corsiva"; > > panose-1:3 1 1 1 1 2 1 1 1 1; > > mso-font-charset:0; > > mso-generic-font-family:script; > > mso-font-pitch:variable; > > mso-font-signature:647 0 0 0 159 0;} > >@font-face > > {font-family:Tahoma; > > panose-1:2 11 6 4 3 5 4 4 2 4; > > mso-font-charset:0; > > mso-generic-font-family:swiss; > > mso-font-pitch:variable; > > mso-font-signature:553679495 -2147483648 8 0 66047 0;} > >@font-face > > {font-family:Haettenschweiler; > > panose-1:2 11 7 6 4 9 2 6 2 4; > > mso-font-charset:0; > > mso-generic-font-family:swiss; > > mso-font-pitch:variable; > > mso-font-signature:647 0 0 0 159 0;} > > /* Style Definitions */ > >p.MsoNormal, li.MsoNormal, div.MsoNormal > > {mso-style-parent:""; > > margin:0in; > > margin-bottom:.0001pt; > > mso-pagination:widow-orphan; > > font-size:12.0pt; > > font-family:"Times New Roman"; > > mso-fareast-font-family:"Times New Roman";} > >a:link, span.MsoHyperlink > > {color:blue; > > text-decoration:underline; > > text-underline:single;} > >a:visited, span.MsoHyperlinkFollowed > > {color:purple; > > text-decoration:underline; > > text-underline:single;} > >p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig > > {margin:0in; > > margin-bottom:.0001pt; > > mso-pagination:widow-orphan; > > font-size:12.0pt; > > font-family:"Times New Roman"; > > mso-fareast-font-family:"Times New Roman";} > >span.EmailStyle15 > > {mso-style-type:personal-reply; > > mso-ansi-font-size:11.0pt; > > mso-ascii-font-family:"Comic Sans MS"; > > mso-hansi-font-family:"Comic Sans MS"; > > mso-bidi-font-family:Arial; > > color:navy; > > font-weight:normal; > > font-style:normal;} > >p.BodyCopy, li.BodyCopy, div.BodyCopy > > {mso-style-name:"Body Copy"; > > mso-style-update:auto; > > margin-top:0in; > > margin-right:0in; > > margin-bottom:7.0pt; > > margin-left:0in; > > line-height:14.0pt; > > mso-line-height-rule:exactly; > > mso-pagination:widow-orphan; > > font-size:11.0pt; > > mso-bidi-font-size:10.0pt; > > font-family:Garamond; > > mso-fareast-font-family:"Times New Roman"; > > mso-bidi-font-family:"Times New Roman";} > >span.EmailStyle18 > > {mso-style-type:personal; > > mso-ansi-font-size:10.0pt; > > mso-ascii-font-family:Arial; > > mso-hansi-font-family:Arial; > > mso-bidi-font-family:Arial; > > color:black;} > >@page Section1 > > {size:8.5in 11.0in; > > margin:1.0in 1.25in 1.0in 1.25in; > > mso-header-margin:.5in; > > mso-footer-margin:.5in; > > mso-paper-source:0;} > >div.Section1 > > {page:Section1;} > >--> > ></style> > ><!--[if gte mso 9]><xml> > > <o:shapedefaults v:ext="edit" spidmax="1027"/> > ></xml><![endif]--><!--[if gte mso 9]><xml> > > <o:shapelayout v:ext="edit"> > > <o:idmap v:ext="edit" data="1"/> > > </o:shapelayout></xml><![endif]--> > ></head> > > > ><body bgcolor=white lang=EN-US link=blue vlink=purple style='tab-interval:.5in'> > > > ><div class=Section1> > > > ><p class=MsoNormal><span class=EmailStyle15><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.<span style="mso-spacerun: yes"> </span>It needs to be > >configured.<span style="mso-spacerun: yes"> </span>It also depends on > >what version of the database you are using.<span style="mso-spacerun: > >yes"> </span>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.<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle15><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"'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle15><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"> </span>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.<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle15><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"'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle15><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.<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle15><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"'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><!--[if supportFields]><span class=EmailStyle15><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"'><span style='mso-element: > >field-begin'></span><span style="mso-spacerun: yes"> </span>AUTOTEXTLIST > >\s "E-mail Signature" <span > >style='mso-element:field-separator'></span></span></font></span><![endif]-- ><spa > >n > >class=EmailStyle18><b style='mso-bidi-font-weight:normal'><i > >style='mso-bidi-font-style: > >normal'><font size=2 color="#3366ff" face="Monotype Corsiva"><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<o:p></o:p></span></font></i></b></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><font size=2 color=black > >face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: > >Arial'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><b style='mso-bidi-font-weight: > >normal'><font size=2 color=blue face=Tahoma><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<o:p></o:p></span></font></b></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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:<s pan > >style='mso-tab-count:1'> &nb sp; > ></span>(248) > >865-4350<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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:<s pan > >style='mso-tab-count:1'> &nb sp; > ></span>(248) > >408-2918<o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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:<sp an > >style='mso-tab-count:1'> &nb sp;&n > >bsp; </span><a > >href="mailto:[EMAIL PROTECTED]";><font size=3 color=red><span > >style='font-size:12.0pt;color:red'>[EMAIL PROTECTED]</span></ font> > ></a><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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'> &nb sp;&n > >bsp; </span><a > >href="http://www.compuware.com/";><font size=3 color=red><span style='font-size: > >12.0pt;color:red'>www.compuware.com</span></font></a><o:p></o:p></span></fo nt></ > >span></p> > > > ><p class=MsoNormal><span class=EmailStyle18><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'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal><!--[if supportFields]><span class=EmailStyle15><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"'><span style='mso-element: > >field-end'></span></span></font></span><![endif]--><span > >class=EmailStyle15><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"'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=2 color=black > >face=Tahoma><span > >style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original > >Message-----<br> > ><b><span style='font-weight:bold'>From:</span></b> Sona > >[mailto:[EMAIL PROTECTED]]<br> > ><b><span style='font-weight:bold'>Sent:</span></b> Tuesday, January 15, 2002 > >7:20 PM<br> > ><b><span style='font-weight:bold'>To:</span></b> Multiple recipients of list > >ORACLE-L<br> > ><b><span style='font-weight:bold'>Subject:</span></b> Why doesn't Oracle kill > >dead connections?</span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New > >Roman"><span > >style='font-size:12.0pt'><![if > >!supportEmptyParas]> <![endif]><o:p></o:p></span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=2 color=black > >face=Arial><span > >style='font-size:10.0pt;font-family:Arial;color:black'>Hi</span></font><fon t > >color=black><span > >style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=2 color=black > >face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black'>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></font><font color=black><span style='color:black; > >mso-color-alt:windowtext'><o:p></o:p></span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=2 color=black > >face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black'>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></font><font color=black><span style='color: > >black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=2 color=black > >face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black'>Is > >there any way to force Oracle to kill the session when the user closes the > >browser?</span></font><font color=black><span style='color:black;mso-color-alt: > >windowtext'><o:p></o:p></span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=3 color=black > >face="Times New Roman"><span > >style='font-size:12.0pt;color:black'> </span></font><font > >color=black><span > >style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > > > ><p class=MsoNormal style='margin-left:.5in'><font size=2 color=black > >face=Arial><span > >style='font-size:10.0pt;font-family:Arial;color:black'>TIA</span></font><fo nt > >color=black><span > >style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > > > ></div> > > > ></body> > > > ></html> > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
