Puzzle - Abandoned Terminal.
From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 15 Feb 2011 13:04:49 +0000
Message-ID: <AANLkTimh10xuRHSH-AH7RnpVtZyphhkqAr3yySeOJnK__at_mail.gmail.com>
We were just chatting about the problem of users abandoning their terminals
Date: Tue, 15 Feb 2011 13:04:49 +0000
Message-ID: <AANLkTimh10xuRHSH-AH7RnpVtZyphhkqAr3yySeOJnK__at_mail.gmail.com>
We were just chatting about the problem of users abandoning their terminals
and the question arose - How long could a user leave an uncommitted
transaction
before it got rolled back?. Which mechanism do we thionk would eventually
deal with it?
I know the DBA gets called if a deadlock occurs but theoretically how long could it sit there.
--
Howard A. Latham
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 15 2011 - 07:04:49 CST