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
from V$SESSION A, V$SQL B
where A.SQL_ADDRESS = B.ADDRESS
AND A.SQL_HASH_VALUE = B.HASH_VALUE