查询正在进行的sql 进程

查看所有

select b.sid, b.username, b.serial#, a.spid, b.paddr, c.sql_text, b.machine
  from v$process a, v$session b, v$sqlarea c
 where a.addr = b.paddr  
   and b.sql_hash_value = c.hash_value;

image.png

删除

  select sql_text,
       b.sid,
       b.serial#,
       'alter system kill session''' || b.SID || ',' || b.serial# || ''';',
       b.username
  from v$process a, v$session b, v$sqlarea c
 where a.addr = b.paddr
   and b.sql_hash_value = c.hash_value
     and sql_text LIKE '%dust_%'
     ;

image.png