Version 2.2.1.824 of Mumbai is available for download. Here’s the list of changes:

• Added ASH data viewer (supports ASH and BASH data)
• Added one-click 10046 tracing for scripts in the console window
• Lots of small tweaks and fixes

After releasing the BASH package that makes active session history data available without a Diagnostic Pack license, an ASH data viewer in Mumbai was the logical next step.

The layout as shown below is similar to what you might know from the ASH data shown in Enterprise Manager/Cloud Control/DB Console or from ASH Viewer, but there are, in (more...)

BASH – It’s ASH for the rest of us

Note: This is a historic blog post, that is no longer being updated. Please go to the BASH page for up-to-date information.

If you, like me, work with Standard Edition, Standard Edition One or don’t have a license for Oracle’s Diagnostic Pack, you probably miss Oracle’s ASH (Active Session History) badly. While Statspack, in my opinion, still can fill most of the gap the unavailable AWR leaves on SE/SE1, at least I miss ASH very much.

Like lots of DBAs and consultants, I am a huge fan of Tanel Poder’s snapper (more...)

Presenting at DOAG 2011 was a great experience, so I am very happy to present again at DOAG 2012. The title of the session is “Analysis and Visualizing Statspack and AWR data” (it will be in german language though).

Here’s the abstract:


Der Referent gibt eine Überblick über Statspack und Automatic Workload Repository (AWR), erläutert die Konzepte um die meist großen Mengen von vorhandenen Statspack/AWR Daten zu analysieren und führt in Demos vor, wie diese Konzepte in "Mumbai", einem frei-verfügbaren Windowsprogramm u.a. zur Oracle Performanceanalyse, implementiert wurden.
Der Referent zeigt die Probleme der Durchschnittsbildung, die Grenzen der Statspack/AWR Daten (more...)

No rocket science here, but since I use it so frequently, I thought this might be actually usefull for others, too.

Quote from the Readme.txt file:


WHAT IS THE POINT?
Once installed, the two tables, the PL/SQL package and the scheduler job
make it very easy to record regular snapshots of the results of SQL queries.

Since this is something I frequently need to do, e.g. for performance data
not snapped by STATSPACK/AWR, tracking a list of invalid objects in developer
schemas over longer periods of time, recording AUDIT information from remote
test/dev databases that are cloned from (more...)

Version 2.2.1.821 of Mumbai is available for download.

Here’s the list of changes:

• There is now a second page control on the left side of the main window where you can drag and drop pages to or you can right-click on a tab and select “Move to other side” to have a side-by-side view:

• The bind variables panel in the console window can now be collapsed:

• Package detail view: A view which combines the package and package body into one view with a procedure/function navigation tree and a list of errors in the package if there are (more...)

The databases I look after in my day job always showed a pretty low MREADTIM value, just a little above SREADTIM. Recently, the disks in our SAN were changed and we now have a huge caching module installed and now I consistently see MREADTIM values significant below SREADTIM. It seems that with MREADTIM ‹ SREADTIM Oracle reverts to calculating these values as it does when only NOWORKLOAD statististics are available. When doing this, Oracle ends up with an MREADTIM › SREADTIM.

I still don’t understand the rationale for this behaviour, since my idea of system and object statistics is that they should (more...)

Version 2.2.1.809 of Mumbai is available for download.

Here’s the list of changes:

• SQL*Plus “exec” command now is supported with “Run script” in console window
• When running a script against multiple databases the “Fetch DBMS_OUPTPUT” option is now applied correctly over new connections
• Fixed the position of the encrypt button in the connection dialog
• Added missing join predicate on OWNER columns in “Unindexed foreign keys” query
• Added columns constraint_name, referenced_owner, referenced_table and referenced_columns in “Unindexed foreign keys” view
• You can now retrieve a custom number of lines from the alert.log instead of the fixed number of (more...)

Version 2.2.1.804 of Mumbai is available for download.

Here’s the list of changes:

• You can now create your own keyword lists in the console window

  

• You can now search for the SQL text by OLD_HASH_VALUE (Ctrl+Q shortcut)

  

• Added SQL statement history in console window (CTRL+H)

  

• Fixed the vanishing bind variable grid after running scripts in the console window
• Fixed some of the default filters in the parameter views and now including parameters with ISMODIFIED=TRUE
• Fixed row count showing up as zero in the status bar of the console window for queries with bind variables
• The external tables (more...)

Version 2.2.1.801 of Mumbai is available for download.

Lots of small changes and fixes and a few nice new features and enhancements. I hope you like it and if you do, please spread the word.

Here’s the list of changes:

• The context menu for data grids in the console window now has menu actions depending on the column names returned by the query (e.g. column named “SID” give you a menu item “Jump to session table…”)
  E.g. when you execute the query “select * from dba_objects”, Mumbai looks at the column names returned and offers (more...)