How to Kill the Session Block

select * from dba_blockers;

HOLDING_SESSION
---------------
            332

select inst_id,sid,serial#,spid,username,program from gv$session where sid=332;


ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;