how to trace other session

[craigdba]

exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);