推荐一款性能诊断工具-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

 

 


Posted

in

by

Tags:

Comments

9 responses to “推荐一款性能诊断工具-Membai”

  1. larry.hong Avatar
    larry.hong

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

    1. admin Avatar
      admin

      你好,请耐心等待,因该会在短期内恢复的。

  2. testxxh Avatar
    testxxh

    can’t download,404

    1. Maclean Liu Avatar

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

  3. testxxh Avatar
    testxxh

    敬候佳音!

  4. liu.maclean Avatar
    liu.maclean

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

  5. 风 Avatar

    该软件有新版本了吗?

Leave a Reply to Maclean Liu Cancel reply

Your email address will not be published. Required fields are marked *