偶然看到这样一个帖子:slightly OT: another free oracle resource profiler
a free oracle resource profiler project on sourceforge. The actual
url is http://sourceforge.net/projects/oraresprof/
where you can find the first (beta) release and a document which tries
to explain the basic implementation ideas.
The profiler is written in Java and its modular design allows to embed
it in web applications or to produce output formats other than HTML
and txt quite easily.
接着就有大名鼎鼎的Connor Mcdonald
很尖锐的指出:
I have to admit, when processing trace files, I’ve rarely found the
need to go much more sophisticated then (in pseudo-code)10046 level 8 | tkprof | grep ^total | sort | head -3Don’t get me wrong – I’ve been really impressed with the hotsos
profiler, orasrp and the like, but it ain’t normally that hard to find the worst piece of code in a system
引发了一系列的争论.我倒是认为这其实不是个”重新发明轮子”的问题
这一系列讨论中我比较感兴趣的是有人作了一个相似工具的列表:
- hotsos http://www.hotsos.com – paid for perl
- orasrp http://oracledba.ru/orasrp/ – free source available python
-
SimpleProfiler http://www.niall.litchfield.dial.pipex.com
(pl/sql) - traceanalyzer http://metalink.oracle.com
- Trivadis – Trivadis Extended Analysis Tool Not Free(TVD$XTAT)
- ubTools – http://www.ubtools.com/
Not Free
说来说去,还是觉得 tkprof 直接一些.重剑无锋,大巧不工