A shutdown immediate will not log off any current users, but it will prevent new connections from being established. You will still have to wait until current transactions are completed before the shutdown will complete successfully. When you say that the shutdown was hanging, it was probably waiting for all active sessions to complete. We experience the same problem on our production database due to batch processes that run into our backup window (We're currently doing cold backups). If you are performing the shutdown for backup purposes, I recommend coordinating with your application group to ensure their processes are finished before a defined window. In our experience, doing a shutdown abort is very dangerous due to the inconsistency in which you leave the database and even doing a shutdown immediate is not recommended. Try for the shutdown normal. Just my 2 cents worth. Loren Received on Wed Sep 13 1995 - 00:00:00 CEST
Loren
Original text of this message