Sometimes you have just SQL_ID and you need to find sessions related with this SQL_ID, then you can find like below and you can generate kill script like below. WHERE event LIKE 'SQL*Net message from client%')ДЄnd s.saddr not in ( select SES_ADDR from v$transaction ) You can change event to kill any other event group sessions. You can generate kill session script like below. alter system kill session '63,1963' Д¬ustomer offers you to killВ sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions. You can kill any session with its SID and SERIAL# number like below. select s.SID,s.SERIAL#,S.USERNAME from v$session s where s.sid=63 You need to find session SID and SERIAL# with below script. Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions. Query result will be like below if you have blocking session in your database.ДЄlter system kill session system kill session system kill session Locked Session Sql_address,blocking_session,wait_class,event,p1,p2,p3,seconds_in_waitДЇROM gv$session s WHERE blocking_session_status = 'VALID'ДЇROM gv$session WHERE blocking_session_status = 'VALID') You can generate Kill script of Blocking sessions like below. || s2.username || || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_statusДЇrom gv$lock l1, gv$session s1, gv$lock l2, gv$session s2 || ' ( THIS SID=' || s1.sid || ' ) is blocking ' You can find momentarily blocking session and lock with below scripts. Order by 1 desc) sub where sub.sql_id=v.sql_id

Owner||'.'||object_name||':'||nvl(subobject_name,'-') obj_name,s.program,s.module,s.machineДЇrom dba_hist_active_sess_history s, dba_objects o (select sample_time,s.sql_id sql_id, session_state, blocking_session, select v.sql_text,v.sql_fulltext,sub.* from v$sql v, Change date time column which is specified with bold character. You can find historical blocking session and lock with below scripts. Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA ) Oracle DBA ( Database Administrator ) needs useful scripts to monitor, analyze and check Oracle database for routine database operations and monitoring.Д«efore Oracle DBA Scripts, If you donвЂ™t know Oracle database and want to learn, click following link to start learning Oracle database with this tutorial. ) in this tutorial series.ДЇind Blocking Sessions and Kill Locked Session Scripts & Locked Objects in Oracle I will share Find Blocking Sessions and Kill Locked Session Scripts & Locked Objects scripts and otherВ Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.

Oracle kill session for user