Something about that makes sense. If a connection has some type of lock in
progress, it cannot be disconnected until the transaction is completely
rolled back and the lock is released. If there are multiple users with such
locks then the problem would be compounded.
Ken
>
> Hi.. I have also come across this problem. What i did was to kill the
> user processes connecting to the database using OS command. Though the
> immediate option is supposed to do this, if this is done, then shutdown
> immediate works fine. Shutdown abort requires a recovery at the next
> startup. Any more solutions and suggestions will be of great use..
Received on Fri Jun 25 1999 - 07:01:03 CDT
