支持左连接的 Oracle 9i 以上版本
1 2 3 4 5 |
select OSUSER, PROGRAM, USERNAME, SCHEMANAME, B.Cpu_Time, STATUS, B.SQL_TEXT from V$SESSION A LEFT JOIN V$SQL B ON A.SQL_ADDRESS = B.ADDRESS AND A.SQL_HASH_VALUE = B.HASH_VALUE order by b.cpu_time desc |
Oracle 8i 及以前的版本中
1 2 3 4 5 6 7 |
select OSUSER, PROGRAM, USERNAME, SCHEMANAME, STATUS, B.SQL_TEXT from V$SESSION A, V$SQL B where A.SQL_ADDRESS = B.ADDRESS AND A.SQL_HASH_VALUE = B.HASH_VALUE --后面可以加上你要的约束条件 and OSUSER = 'Unmi' AND USERNAME = 'APPS' and PROGRAM = 'JDBC-1.0-Client' |
自行决定要查询出来的字段以及约束条件。