oralce查看正在执行的sql

select * from v$session;---查询session
---根据sessionid来查询sql
select sql_text
    from v$sqltext
    where (hash_value, address) in (
    select decode (sql_hash_value, 0, prev_hash_value, sql_hash_value),
           decode (sql_hash_value, 0, prev_sql_addr, sql_address)
        from v$session
        where sid = 3066);