Re: Why is it so difficult to shutdown Oracle?

SHUTDOWN NORMAL --> wait for all users to disconnect SHUTDOWN IMMEDIATE --> disconnect al users, rollback all pending transactions

                       and then shutdown the server. This process can
last a
                       but ...
SHUTDOWN ABORT     --> shutdown the server, all pending transactions
will
                       be rolled back when the server will be started

 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.

 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