• 推荐一款性能诊断工具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    
  • 相关阅读:
    微信小程序---自定义三级联动
    jQuery分页插件
    微信小程序点击图片放大
    微信小程序----日期时间选择器(自定义精确到分秒或时段)
    PHP文件上传error的错误类型
    获取url传的参数转变为对象的方法
    mysql忘记密码时,重新修改密码
    表单注册及自定义validate手机验证码验证实例
    登陆jq表单验证及jqcookie记住密码实例
    iframe高度自适应,自适应子页面高度
  • 原文地址:https://www.cnblogs.com/macleanoracle/p/2967773.html
Copyright © 2020-2023  润新知