where to get TKPROF with wait event statistics output, preferably free?
Printable View
where to get TKPROF with wait event statistics output, preferably free?
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
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,