select a.program, b.spid, c.sql_text
from v$session a, v$process b, v$sqlarea c
where a.paddr = b.ADDR
and a.SQL_hash_value = c.hash_value
and a.username is not null
from v$session a, v$process b, v$sqlarea c
where a.paddr = b.ADDR
and a.SQL_hash_value = c.hash_value
and a.username is not null
and a.program='plsqldev.exe'
oracle 查询被锁资源
select sid,serial#,username,osuser from v$session where sid in (select session_id from v$locked_object);
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;
alter system kill session '397,55545'