How can I delete locks in Oracle Database?
Posted on 2002-07-30
I use TOAD program to see locks in database.
Sometimes, I'd like to kill all of them because of the database problems. However I can't do it. Some of them can't be killed. I get 'the session was marked with killed-Ora31.
How can I kill the locks that I couldn't kill?