Re: Puzzle - Abandoned Terminal.

From: <TESTAJ3_at_nationwide.com>
Date: Tue, 15 Feb 2011 08:07:10 -0500
Message-ID: <OFCC9E4EC3.8F32B217-ON85257838.0047FEAD-85257838.00481297_at_lnotes-gw.ent.nwie.net>

I would think it could sit there forever, but if you have like sqlnet timeout, that would force the "dead" transaction to close the session and rollback. I know thats what I've used in the past.

joe

---

Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

From:
Howard Latham <howard.latham_at_gmail.com> To:
ORACLE-L <oracle-l_at_freelists.org>
Date:
02/15/2011 08:06 AM
Subject:
Puzzle - Abandoned Terminal.
Sent by:
oracle-l-bounce_at_freelists.org

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:07:10 CST