Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.   You can read other Kill Session Scripts in Oracle.   Oracle Kill Session Scripts -1 https://ittutorial.org/oracle-kill-session-scripts-2/ https://ittutorial.org/oracle-kill-session-scripts-3/   gv$lock view lists the locks currently held by the … Continue reading Oracle Kill Session Scripts -4 and gv$lock view