Re: Puzzle - Abandoned Terminal.
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Jed_Walker@xxxxxxxxxxxxxxxxx
- Date: Tue, 15 Feb 2011 08:01:40 -0800
On Tue, Feb 15, 2011 at 6:22 AM, Walker, Jed S <Jed_Walker@xxxxxxxxxxxxxxxxx
> 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
Other related posts:
