查询oracle用户正在活动的任务sql

SELECT b.inst_id,b.sid oracleID,
b.username 登录Oracle用户名,
b.serial#,
spid 操作系统ID,
paddr,
sql_text 正在执行的SQL,
sql_fulltext,
b.machine 计算机名,
b.EVENT,
‘alter system kill session ‘’’||b.sid||‘,’||b.serial#||‘’‘;’
FROM gv$processa,gv$session b, gv$sql c
WHERE a.addr = b.paddr
AND b.sql_hash_value = c.hash_value
and a.inst_id=1
and b.inst_id=1
and c.inst_id=1
and b.status=‘ACTIVE’