select the sid and serial# from v$session.

THen, connect as sys. Execute dbms_system.set_sql_trace_in_session(sid, serial#, 'TRUE');

The trace file is created in the user_dump_dest directory specified in the init.ora file.

execute the same command with FALSE to stop tracing.