LAZY tuner: where to get TKPROF with wait event stats

[LND]

where to get TKPROF with wait event statistics output, preferably free?

[sambavan]

I hope this article on metalink would give you some solution.

Doc ID: Note:102925.1
Subject: Tracing sessions: waiting on an enqueue

check it out.

Sam

[jmodic]

Oracle's (free, comes with the database) utilities UTLBSTAT/UTLESTAT will produce you a report with a section on wait events statistics. In 8.1.6 those two utilities have been much improved in a utility called STATSPACK. I haven't played with it yet, however there were some in-depth articles about STATSPACK in some later isues of Oracle Magazine, and my impresion after reading those articles was that Statspack is a couple of magnitutes more powerfull than utlB/Estat

HTH,