正在执行的SQL

select sid,v$session.serial#,v$process.spid,v$session.username,last_call_et,status,LOCKWAIT,machine,logon_time,sql_text from v$session, v$process, v$sqlarea where paddr = addr and sql_hash_value = hash_value and v$session.username is not null and sql_text not like '%session%' and status='ACTIVE' order by last_call_et desc;