Trace分析工具: SwingBench Trace Analyzer

Posted on November 15, 2006

Oracle常用的Trace分析工具是tkprof，对于官方的工具我一项支持并喜欢使用。

如果你遇到以下情况：

  1. 本地没有安装Oracle数据库，没有tkprof程序。
  2. 你需要登录服务器去抓取trace文件。
  3. 你厌倦在putty中麻烦的指令。

不妨尝试一下SwingBench Trace Analyzer。

这是一款用Java编写的有GUI的Trace Analyzer。它的图形界面画的非常漂亮而简便，并且令人赏心悦目 :P

事实上，作者正是对tkprof有点小意见才写了这个软件：

Now I know TKProf does a fine job of this but I’ve never been really comfortable with having to continually rerun TKProf to change the ordering and filter out classes of statements. This came to a head just recently after looking through a big trace file and trying to figure out what SQL to work on first. I also thought that perhaps I could use a richer user interface to give a better overview on what has happened a particular run. So I started with the intention of figuring out how to parse the file and come up with some ideas on what to with the results…

(自己动手，丰衣足食？)

目前，它已经实现了以下几个功能：

  • Parse trace files (分析trace).
  • Profile the data via a bar of the right had side of the scroll bar (滚动条).
  • Supports dynamic filtering and sorting of the data (动态过滤和排序).
  • Highlight the 5 worst performing pieces of SQL (elpased, cpu, physical etc) (高亮5个最差SQL).

将要实现的：

  • highlight concurrent SQL (高亮当前SQL).
  • Explain Plans (执行计划).
  • Display bind variables (显示bind var).
  • dump sql to flat files (导出SQL).
  • generate load files for swingbench (为swingbench生成载入文件).
  • create a plugin for SQL*Developer (做SQL*Developer的插件).

(注：swingbench是一款性能负载工具)

有兴趣的人可前去留言，留言地址：http://www.dominicgiles.com/comments.php

Related Posts

  1. Planning Manager诊断过程和10046事件
  2. 案例：主物料界面性能问题
  3. Trace Analyzer

» Filed Under Database Print This Post Print This Post

Comments

Leave a Reply