SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… Read More »SQL Statement Hang? Why?
Here I introduce a trigger which can log logon information on specific schemas. It will kill their sessions if they are not from specific subnet.… Read More »How to Kill Session in Logon Trigger
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