"select sid,serial# from v$session where username"

SQL Trace を取得する方法 - DBMS_MONITOR - SQL shutdown abort

select sid,serial# from v$session where username = 'xxxx';
exec dbms_monitor.session_trace_enable(148,46);