viji (7/23/2009)
1. KILL the processes which is active / suspended / sleeping etc on the database 😀
Instead of killing all active sessions, you can fire this simple statement to terminate all sessions and bring the db offline
alter database mydb set offline with rollback immediate