I will share Find Oracle blocking sessions and Kill Locked Session Scripts & Locked Objects scripts and other Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) …
Read More »Tag Archives: oracle identify sql holding lock
Oracle Kill Session Scripts -4 and gv$lock view
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.
Read More »