Lê Cường's Blog

Tình cờ phát hiện ra cái tool để monitoring, healh check cơ sở dữ liệu Oracle hoàn toàn miễn phí & cực kỳ trực quan nên share luôn.

Tool này dùng cho Oracle DBAS và Colsultants, chú trọng vào việc phân tích performance.

Tính năng:

• 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

Lê Cường

Life is something that no one can teach you. You have to learn it.
Follow him on