Re: Oracle Trace Analyzer

From: Jonathan Lewis <>
Date: Fri, 4 Jan 2013 09:31:44 -0000
Message-ID: <>

"Mladen Gogala" <> wrote in message
| On Fri, 04 Jan 2013 07:16:49 +0000, Jonathan Lewis wrote:
| > My memory of versions may be a little hazy, but I think I first saw
| > tkprof in 6.0.27 - then found that it had disappeared in the 6.0.29
| > upgrade, so I used awk to recreate it. Dead easy if you've got a
| > language that deals with associative arrays, though at the time the
| > concept was so new that no-one was thinking about subtracting resources
| > for recursive SQL from the triggering SQL and all the other clever
| > Then tkprof re-appeared in 6.0.33
| Well, parsing strings is not a problem and computing summaries is not a
| big problem, but tkprof also draws plans and so does TRCA.

I don't recall if I did the plans in awk - it wouldn't have been too hard since the id and pid are in the STAT lines, it only a case of simple counting of extra spaces. But I dropped the project when tkprof came back in 6.0.33.


Jonathan Lewis

Author: Oracle Core (Apress 2011) Received on Fri Jan 04 2013 - 10:31:44 CET

Original text of this message