How to get a sure kill for user sessions
From: Richard Hammel <r_hammel_at_mindspring.com>
Date: 1995/06/06
Message-ID: <3r2lct$vp4_at_firehose.mindspring.com>#1/1
Date: 1995/06/06
Message-ID: <3r2lct$vp4_at_firehose.mindspring.com>#1/1
We have a cold backup that executes every Sunday morning at 12:15am. On a couple of occasions, the database has failed to go down because there were user sessions marked as KILLED but nonetheless, Oracle would not shutdown. We could do a shutdown immediate, but Oracle says that this is not a clean shutdown and that you should not do a cold backup after a shutdown immediate. What we need is a way to perform the equivalent of a kill -9 on Oracle user sessions. Any suggestions would be greatly appreciated!
- Rick Hammel