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功能见下图:
Membai最新的版本是1.1.1.185 (released 17 Apr. 2011): Download here
非常不错,不过无法下载了,你是否可以发到我的邮箱呢?
你好,请耐心等待,因该会在短期内恢复的。
can’t download,404
你好,可能是写该工具的这位老兄懒得维护网站了, 我会尝试联系他以取得共享这款工具的许可,请耐性等待。
敬候佳音!
~ 作者更新了~
Mumbai version 2.1.1.689
http://dl.dropbox.com/u/23825856/Mumbai%20Downloads/Mumbai_v2.1.1.689.zip
Good Reply !
Mumbai_v1.1.1.185 已上传到 http://t.askmaclean.com/thread-848-1-1.html
该软件有新版本了吗?