老兄试试这个,其他信息可以扩充
select t.username, t.status , t.osuser , t.machine, t.action, t.command,s.sql_text ,s.first_load_time
from v$session t , v$sql s
where t.osuser = 'sexroute'
and t.status = 'ACTIVE'
and t.sql_address = s.address
and t.sql_hash_value = s.hash_value
select c.user_name,s.status,s.osuser,s.machine, s.program,c.sql_text
from v$open_cursor c, v$session s
where c.sid = s.sid
and s.status='ACTIVE'
and s.user_name = 'sexroute'