Category Archives: locking session oracle blocking session contention

Identify and kill the locking session(s) automatically

# This script will generate kill session(s) script with session and other information and kills the session (s) automatically. #!/bin/sh export RUN_DATE=`date ‘+%y_%m_%d_%H_%M’` # Number of seconds since last activity had happened. (10 mins) change as per your requirement export … Continue reading

Posted in locking session oracle blocking session contention | Tagged | 1 Comment