>----- Original Message ----- >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 11 Sep 2002 05:13:28 > >Hi All, > >We have users who sql access who will issue long >running queries(you know >the type) and just shuts down their computer while >running. > >I assume once sent to the server that server is >still executing it or will >it die once connection is broken. Can someone >explain what actually >happens in this scenario. > >Is there anyway to detect/kill process. > >Thanks >Rick >
Rick, When a user runs a query it sends it (usually via a TCP/IP socket) to a server process which runs it on its behalf. It is possible to ask for sockets to test the link at regular intervals in which case you receive a SIGPIPE signal when it is broken but I don't know if Oracle does it (it must have a cost) nor if it does it on all platforms nor in all configurations (MTS springs to my mind). In any case, the server detects that something is wrong when it has some result to send back, in which case pmon can terminate and clean the session (in the favorable case :-)), but I doubt it is done earlier. I must say that I were Oracle I wouldn't rush to terminate things, especially when you have some features such as transparent application failover and all kind of 'transparent' retries which you may have to deal with. There must be some timeout before any action is taken. I don't think that you can spot such a case, short of checking from the server that you can ping the clients (get 'machine' in V$SESSION) and/or check that the (OS) pid which started the session is still alive and kicking on the client machine. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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).
