Hi !

I am using BLAT tool for analyzing my session which runs slow for the first time. For the subsequent runs the session performs absolutely fine. After going thru the performance optimization document I learnt that BLAT will give the proper details for similar problems. I tried to generate the log file using "BLAT="sess s 01" OR "BLAT="sql s 01111". I am unable to format the output using btop6.1. The only thing I can see is the header "Pid Sid Qid Tot time Query text" and no details.

I used the following command:
btop6.1 -ototal -log <log file>

Can somebody guide how can I use the btop6.1 or bls6.1?

thanks
:confused:

Have you tried the Call Graph Profiler?

you can activate it using these parameters: -set PROFILE_ALL=1 -set PROF_DIR=<profiledir>