trace query

use the following to trace another session:

dbms_system.set_bool_param_in_session(sid, serial#, 'timed_statistics',true);
dbms_system.set_sql_trace_in_session(sid,serial#,truefalse);

note: There are plenty of other options, and the above are just defaults.