First find the user_dump_dest directory with the SHOW PARAMETER DUMP
command in SQL*Plus.  Then go to that directory (for example,

  cd /u01/app/oracle/product/10.2.0/db_1/admin/orcl/udump

After reviewing the contents of your trace file, execute tkprof,
specifying an output file.  For example if your trace file is named
orcl_ora_16969_trace_lab_s1.trc, and you create your output file in
the /tmp directory, then:

  tkprof orcl_ora_16969_trace_lab_s1.trc /tmp/trace_lab_s1

If you don't give your output filename an extension, tkprof will add
the ".prf" extension.  Open and review the output file:

  more /tmp/trace_lab_s1.prf

Locate the query you executed.
