Re: Puzzle - Abandoned Terminal.
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 15 Feb 2011 08:01:40 -0800
Message-ID: <AANLkTimcKexmFuQ4JmdtsTn2WWyLE+eL6kc9U4t2Z3uk_at_mail.gmail.com>
On Tue, Feb 15, 2011 at 6:22 AM, Walker, Jed S <Jed_Walker_at_cable.comcast.com
> wrote:
Date: Tue, 15 Feb 2011 08:01:40 -0800
Message-ID: <AANLkTimcKexmFuQ4JmdtsTn2WWyLE+eL6kc9U4t2Z3uk_at_mail.gmail.com>
On Tue, Feb 15, 2011 at 6:22 AM, Walker, Jed S <Jed_Walker_at_cable.comcast.com
> wrote:
> It would sit, unless you have a profile (or semething else –FW timeout,
> etc) that would kill it.
>
>
>
> Oracle takes care of deadlocks by killing one of the sessions. If the user
> holds a lock (and there is no deadlock) then it will just sit there until
> the session is killed (this is why they gave us “shutdown immediate”)
>
Just to clarify for newbies out there, what I think you are referring to is that prior to the availability of 'shutdown immediate', shutting down the database when there were open transactions required a shutdown abort.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 15 2011 - 10:01:40 CST