select sid,user_name,sql_text
from v$open_cursor
where sid in (select sid from (select sid,serial#,username,program
from v$session
where status='ACTIVE'));
可以在where 加上user_name='name' 查看特定用户真正在执行的sql
select sid,user_name,sql_text
from v$open_cursor
where sid in (select sid from (select sid,serial#,username,program
from v$session
where status='ACTIVE'));
可以在where 加上user_name='name' 查看特定用户真正在执行的sql