Tuesday, September 14, 2010

performance of tkprof vs orasrp

Usually tkprof is faster than orasrp. But there are some cases when tkprof processes trace file slower than orasrp. Take for example today's situation.

1.7Gb trace file with about 16 thousands of different statements. Total number of calls is about 10 millions (although, it doesn't matter). OraSRP processed this file for 3 minutes. Tkprof for HP-UX processed it for 5 minutes. Tkprof for Linux consumed 1.5Gb of virtual memory and didn't finish in an hour.

The source of the problem lies in the big number of statements. When the number of statements in trace file is more than, say, 10 thousands, tkprof performs worse than orasrp and may even stuck.

Labels: ,