oracle干掉session

  SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine,
s.terminal, s.logon_time, l.type,c.sql_text
FROM v$session s, v$lock l, v$sqlarea c
WHERE s.sid = l.sid
and  s.sql_id=c.sql_id
AND s.username IS NOT NULL
ORDER BY sid;

select * from dba_waiters;
select a.waiting_session , b.username ,c.sql_text
          from     dba_waiters a , v$session b , v$sqlarea c
         where    a.waiting_session=b.sid
            and     b.sql_id=c.sql_id;
            
            
            
alter system kill session '265,42429'