Check the type of connection of sid 42 in v$session. If it's SHARED then no trace file will generate by dbms_system.set_sql_trace_in_session.