I am not sure if run into this but I do often enough on my SSMS 17.9.1 version - suddenly, the SSMS window will not register any mouse-clicks although it will seemingly look fine. The reason is because there is a Modal Window somewhere hidden. Sometimes, ALT-TAB followed by ESC will do the trick but not … Continue reading SQL Server: SSMS – Hung Symptoms – Mouse-clicks Don’t Register Due To Hidden Modal Window Behind SSMS
The v$session view If you do not know already, to check who is connected and since when, what their connection status is etc., you would use dynamic view v$session. The view has the following columns: You would kill the required session by issuing Note: The IMMEDIATE option of the above command just returns control … Continue reading Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?