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 = 'lkf' AND USERNAME = 'APPS' //后面可以加上你要的约束条件
效果如下图:
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 = 'lkf' AND USERNAME = 'APPS' //后面可以加上你要的约束条件
效果如下图: