Locate current SQL by user, Oracle non-RAC

# example

  1  select s.sid, s.username, sql.sql_text from v$session s, v$sqlarea sql

  2  where s.status='ACTIVE'

  3  and s.type='USER'

  4  and s.sql_address=sql.address

  5* and s.username ='SYS'

[ SYS@localhost ] sql+> /

       SID USERNAME

---------- ------------------------------

SQL_TEXT

--------------------------------------------------------------------------------

       982 SYS

select s.sid, s.username, sql.sql_text from v$session s, v$sqlarea sql where s.s

tatus='ACTIVE' and s.type='USER' and s.sql_address=sql.address and s.username ='

SYS'

1 row selected.