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

Home -> Community -> Usenet -> c.d.o.server -> Re: Killed ODBC connection leaves TX lock in 10g server

Re: Killed ODBC connection leaves TX lock in 10g server

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 27 Apr 2006 15:29:04 GMT
Message-ID: <IyE0CK.FJy@igsrsparc2.er.usgs.gov>


When any application is killed, for any reason, PMON will eventually detect the session is dead. PMON will then clean up after the killed session. This results in the locks being freed.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu Apr 27 2006 - 10:29:04 CDT

Original text of this message

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