Re: Oracle Trace Analyzer

"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news:pan.2013.01.04.09.07.11_at_gmail.com...
| 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
bits.
| > 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.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543 Received on Fri Jan 04 2013 - 10:31:44 CET