View SQL TEXT for user sessions

To view sql text for USER sessions just run folowing sql.

select ses.SID, ses.SERIAL#, ses.USERNAME, ses.OSUSER, ses.MACHINE, ses.PROGRAM,
sqt.SQL_ID, sqt.SQL_TEXT
from v$session ses
join v$sql sqt
on ses.SQL_ID = sqt.SQL_ID
where ses.USERNAME = 'USER';

Sample output:


        19       6967 USER
oracle
node1
sqlplus@node1 (TNS V1-V3)                        83d6tua6t4q49
select ses.SID, ses.SERIAL#, ses.USERNAME, ses.OSUSER, ses.MACHINE, ses.PROGRAM,
 sqt.SQL_ID, sqt.SQL_TEXT from v$session ses join v$sql sqt on ses.SQL_ID = sqt.
SQL_ID where ses.USERNAME = 'USER'