REM  #*****************************************************
REM  # File Name: sid_sql.sql
REM  #
REM  # Purpose: After grabbing their SID with su.sql you, 
REM  #          can then see what SQL they are running
REM  #
REM  #*****************************************************

set verify off

select sql_text
from v$sqltext st, v$session ss
where st.address = ss.sql_address
and   ss.sid = &_sid
order by st.address, piece
/