This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status. If you have a situation where single connections are causing a huge blocking chain and you want to kill the absolute minimum number of spids, then this script is for you. There is a safety valve in the script to determine the age of the blocks to kill. By default the script kills only the spids at the top of the blocking chain (Thus freeing all blockers and spids below it) if the blocker is older than 5 seconds.
Drop all connections from a specific database.
2007-10-19 (first published: 2007-07-25)