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.   gv$lock view lists the locks currently held by the Oracle Database and outstanding requests for a lock or latch. You can list the locks running the … Continue reading Oracle Kill Session Scripts -3 and gv$session, gv$lock view