用户正在执行的SQL

SELECT sid, schemaname, osuser, substr(machine, 1, 20) Machine FROM v$session ORDER BY schemaname; SELECT sql_text FROM v$sqlarea WHERE (address, hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid = &1);