查询Oracle正在执行的SQL语句

1select OSUSER, PROGRAM, USERNAME, SCHEMANAME, B.Cpu_Time, STATUS, B.SQL_TEXT
2  from V$SESSION A
3  LEFT JOIN V$SQL B ON A.SQL_ADDRESS = B.ADDRESS
4                   AND A.SQL_HASH_VALUE = B.HASH_VALUE
5 order by b.cpu_time desc

1select OSUSER, PROGRAM, USERNAME, SCHEMANAME, STATUS, B.SQL_TEXT
2  from V$SESSION A, V$SQL B
3 where A.SQL_ADDRESS = B.ADDRESS
4   AND A.SQL_HASH_VALUE = B.HASH_VALUE
5
6   --后面可以加上你要的约束条件
7   and OSUSER = 'Unmi' AND USERNAME = 'APPS' and PROGRAM = 'JDBC-1.0-Client'