Script to kill the top blocker and report what it was doing.

Total article views: 445 | Views in the last 30 days: 27

 Rate this |   Join the discussion |  Briefcase

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.

Total article views: 445 | Views in the last 30 days: 27