推荐一款性能诊断工具-Membai

Marcus Mönnig是一名居住在德国汉堡的Oracle Database顾问及DBA,他开发了一款基于Windows平台的面向Oracle DBA和Consultant的图形化工具-Membai,该软件侧重于性能分析。

Membai在现有的Windows主流操作系统包括XP、2003和win7上都可以流畅工作。唯一的先决条件是需要预装Full Oracle Client客户端软件。Membai所支持的Oracle数据库版本包括从9.2到最新的11.2,因为主要是在10.2上测试,所以部分功能可能在9.2中无法正常工作。

Membai的特性包括:

  • Instant access to important database views vital for DBAs and consultants
  • Retrieved data in Mumbai can be slices and dices in various ways (sorting, filtering, grouping, group arithmetic, etc.)
  • Visualization of data in graphs
  • SQL console window inducing support for bind variables
  • Executions plans for SQL statements from cursor cache, through EXPLAIN PLAN or through DBMS_XPLAN from the Mumbai SQL console window
  • Retrieve alert.log and trace files from the database server to Mumbai and process/analyze them there.
  • Start and stop 10046 traces for any session or process and trace the statements from your SQL console session with just a few clicks
  • Powerful 10046 trace file viewer if you need to dig into the details of a TKPROF or OraSRP report. OraSRP reports can be generated from within Mumbai.
  • Heap dump analyzer that aggregates data from trace files
  • Instant connections to DB server with RDP, putty or WinSCP
  • Run snapper from within Mumbai and let Mumbai visualize the data collected by snapper
  • Analyze Statspack or AWR data, e.g. to find interesting intervals for further analysis

值得一提的是Membai提供了heapdump analyze的功能,这对于经常和heapdump打交道的Oracle Consultant来说是一个福音,此外它同时还提供create dump trace的功能,该功能基本涵盖了主要的Oracle转储和诊断事件,有了它我们无需在忘记dump/trace语句时再去翻手册了。其heapdump analyze和create dump trace功能见下图:

heapdump_analyze

create_dump_function

Membai最新的版本是1.1.1.185 (released 17 Apr. 2011): Download here

 

 

Comments

  1. larry.hong says

    非常不错,不过无法下载了,你是否可以发到我的邮箱呢?

  2. testxxh says

    can’t download,404

    • 你好,可能是写该工具的这位老兄懒得维护网站了, 我会尝试联系他以取得共享这款工具的许可,请耐性等待。

  3. testxxh says

    敬候佳音!

  4. liu.maclean says

    Mumbai_v1.1.1.185 已上传到 http://t.askmaclean.com/thread-848-1-1.html

  5. 该软件有新版本了吗?

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号