Re: Why is it so difficult to shutdown Oracle?
Date: 1996/02/01
Message-ID: <4eprgf$4r4_at_galileo.polito.it>#1/1
Renato Brazioli <brazioli_at_sodalia.it> wrote:
[snip]
> They are all safe. The first one ensures that all transactions complete
>before shutting down, the other two don't but database integrity is
>still
>guaranteed. It depends when you want to wait, at shutdown time or
>startup time.
It also depends on what you're doing at the moment. If you want to bounce the database because one of your SNPx processes is looping at 100% CPU trying to refresh your snapshots nothing else but a SHUTDOWN ABORT will do it.
> Of course it becomes a problem just if you have big transactions.
>--
>______________________________________________________________________________
>Renato Brazioli Sodalia SpA e-mail:
>brazioli_at_sodalia.it
> Via del Brennero, 364 voice: +39(461)316.154
>(direct)
> I-38100 Trento fax: +39(461)316.127
> ITALY
Mauro Fossa
fossa_at_its.it
Standard disclaimers apply Received on Thu Feb 01 1996 - 00:00:00 CET