After the blocking sessions are identified, DBA should notify the session owners and leave them a chance to exit sessions gracefully by themselves. If things… Read More »How Oracle Kill Blocking Sessions
Here I introduce a sample of PL/SQL code to monitor the blocking sessions every N minutes and output in a formatted report. First of all,… Read More »How to Identify Blocking Sessions