Hi,
If I run the trace of session. After I use TKPROF to translate it , it shows me the EXPLAIN plan also. I only need the SQLs run by the seesion, in the sequence it is running. Is there any way..?
Printable View
Hi,
If I run the trace of session. After I use TKPROF to translate it , it shows me the EXPLAIN plan also. I only need the SQLs run by the seesion, in the sequence it is running. Is there any way..?
Don't give explain=user/passwd in the tkprof command.
If you want to know the order of sql statements executed, then the command is:
$tkprof trace_file output_file
Tamil