Lock

SELECT c.owner, c.object_name, c.object_type, b.SID, b.serial#, b.status,
       b.osuser, b.machine
  FROM v$locked_object a, v$session b, dba_objects c
 WHERE b.SID = a.session_id AND a.object_id = c.object_id;

alter system kill session '382,37491';

SQL> select s.sid,s.serial#,s.status,p.spid from v$session s,v$process p where s .username='QAV43' and p.addr=s.paddr;
 SID    SERIAL# STATUS   SPID
---------- ---------- -------- ------------
129      36971 INACTIVE 23892
125       1632 INACTIVE 23900

SQL>alter system kill session '125,1632';