jpirir

select distinct
    b.username user_
    ,d.username blocked_by_user_
    ,t1.time_ 
    ,t1.sql_text
    ,t1.*
from (
    SELECT  distinct a.sql_id, a.blocking_session,a.blocking_session_serial# blocking_session_serial, 
            to_char(a.sample_time,'hh24:mi:ss') time_,
            a.user_id, s.sql_text,a.module

jpirir

select 'alter system kill session '''||sid||','||serial#||''''||' immediate'||';'
from v$session
where username = '';