查询指定表中正在执行的sql语句
select * from v$sql where hash_value in (select hash_value from v$sql_plan where object_owner='××××××' and object_name='××××××')
查询web系统中正在执行的sql语句
select * from v$sql where hash_value in (select hash_value from v$sql_plan where object_owner='××××××' and module='w3wp.exe')