Using TraceAnalyzer instead of TKPROF

As you could know already TKPROF ($ tkprof sys=no explain=apps/) does not take into account bind variables. Therefore, you can not see those values in the output file. If you want to see them, you could use TraceAnalyzer.



1. Download and install the trace Analizae rprogram for your current instance.

2. Using it as follow
Launch: SQL*Plus
connect as APPS/****** (0r user you used to create the raw file)
Run:
SQL> @trcanlzr.sql dbname_ora_11216_SGALARZA.trc
and enjoy the output.

for some reason it only show the BIN values for just some queries, looks like only for more expensive queries.