檢視資料中正在執行的sql

真的很有用，基本每天都會執行：
select to_char(sql_fulltext),v$sqlarea.sql_id,last_call_et continue_time,logon_time,v$process.spid,sid,v$session.serial#,v$sqlarea.hash_value,v$sqlarea.plan_hash_value,v$session.username,LOCKWAIT,machine from v$session ,v$process ,v$sqlarea
  where paddr=addr and sql_hash_value=hash_value 
  and status='ACTIVE' and v$session.username is not null
  order by last_call_et desc;
直接將正在活動的會話殺掉：

殺掉正在執行的sql：
select 'alter system kill session '''||sid||','||serial#||''';' from (   
select sid,v$session.serial#,v$sqlarea.sql_id,v$sqlarea.hash_value,v$sqlarea.plan_hash_value,v$session.username,last_call_et continue_time,LOCKWAIT,machine,logon_time,sql_text from v$session ,v$process ,v$sqlarea
  where paddr=addr and sql_hash_value=hash_value 
  and status='ACTIVE' and v$session.username is not null
  order by last_call_et desc)