Re: Puzzle - Abandoned Terminal.

From: <TESTAJ3_at_nationwide.com>
Date: Tue, 15 Feb 2011 08:26:35 -0500
Message-ID: <OF324D88BB.377C86A1-ON85257838.0049BD1F-85257838.0049D9A7_at_lnotes-gw.ent.nwie.net>

well then the other option would be to use a profile and set idle_time.

joe

---

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

From:
Hemant K Chitale <hemantkchitale_at_gmail.com> To:
TESTAJ3_at_nationwide.com
Cc:
ORACLE-L <oracle-l_at_freelists.org>, howard.latham_at_gmail.com, oracle-l-bounce_at_freelists.org
Date:
02/15/2011 08:19 AM
Subject:
Re: Puzzle - Abandoned Terminal.
Sent by:
oracle-l-bounce_at_freelists.org

DCD would come into play if the client terminal has "gone away' but not if it is just idle (and connected) waiting for the user's next command. Also you might have the sequence wrong. It wouldn't be the transaction closing the session but the other way round (in a manner of speaking). Hemant K Chitale
sent from my smartphone
On 15 Feb 2011 21:08, <TESTAJ3_at_nationwide.com> wrote:
> 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:26:35 CST