Re: shutdown immediate hangs

My understanding is this:

shutdown <normal> waits for all transactions to complete and all users to log out

shutdown immediate completes all pending transactions, preventing new transactions, then waits for all users to log out

shutdown abort stops immediately, pending transactions are rolled back during the next normal startup.

If I am correct, there is a likelihood of a USER thinking that a transaction completed when indeed it was rolled back.

We use shutdown abort all the time.

Killing sessions is (IMHO) misuse.

"Karen Abgarian" <abvk_at_ureach.com> wrote in message news:3D8AB59A.441AF1D2_at_ureach.com...
> I wonder why nobody has responded with an opinion on WHY does oracle
> wait, sometimes indefinitely for shudown immediate. Likely this has to do
> with the famous question of when exactly PMON cleans up the sessions and
> releases the resources after you issue a KILL SESSION command.
>
> It seems to be very popular to shutdown abort and then startup and
shutdown
> normal.
> Even though this works, this is a misuse and it is natural to seek a more
> graceful solution.
>
> The contraindications of killing the sessions in a script are many but
have
> a common root:
> they are difficult to implement properly. A few years ago I wrote such a
> script, it was
> several dozens lines of code. I am not willing to dig it up, but I can
> certify that it is possible.
> The advantage is that you can do shutdown immediate or even normal
instead
> of
> shutdown abort.
>
> Regs
> AK
>
>
>
> Kenneth, Koenraadt wrote:
>
> > On Thu, 19 Sep 2002 12:51:46 +0200, cris <veronesic_at_libero.it> wrote:
> >
> > >Niall Litchfield wrote:
> > >
> > >> 1. issue shutdown ABORT then immediately startup and shutdown normal.
> > >
> > >I was thinking about adding to my script a line that kills all the
> > >active oracle<sid> processes immediatly before to do the shutdown. Is
> > >this a safe way to proceed or are there contraindications?
> > >
> >
> > Safe : NO!!
> > Contraindications : Dozens!
> >
> > Do as Niall says. "Shutdown abort" will kill those processes in a safe
> > way.
> >
> > - Kenneth Koenraadt
> >
> > >Thank you.
> > >Kind regards, Cristian
> > >
>
Received on Fri Sep 20 2002 - 15:12:14 CDT