1.select * from v$session where program='PLSQLDev.exe'
确定SID
2.select spid, osuser, s.program,s.sql_address,q.sql_text
from v$process p, v$session s ,v$sql q
where p.addr=s.paddr
and s.sql_address=q.address
and s.sid=&SID
union all
select spid, osuser, s.program,s.PREV_SQL_ADDR,q.sql_text
from v$process p, v$session s ,v$sql q
where p.addr=s.paddr
and s.PREV_SQL_ADDR=q.address
and s.sid=&SID
/
确定这个SID 是你运行的PLSQL程序
3.select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr and s.sid in(SID);
4.如果是UNIX 就KILL -9 SPID
OR WINDOWS 就ORAKILL ORACLE_SID SPID