Mumbai version available

Version 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 appropriate actions in the context menu of the data table:
  • SQL*Plus “execute” command now is supported with “Run script” in console window


  • Additional login credentials in the console window are now sorted by username:

  • When changing the connection in the main window, the additional login credential buttons are now correctly updated
  • Labels on the x-axis of graphs can now be turned on/off in the “Data shown” tab of the customization window (the default is on for not more than 30 values, otherwise off)
  • Fixed a display bug after incremental search in the Connections drop-down list
  • When wrong credentials for a connection are given in the connection manager, the popup window asking for the correct credentials now shows the “Connect as” selection box
  • Object Dependencies and References are now shown recursively in table/view details
  • Added Object Dependencies and References as context menu item in data grids (see first image above)
  • When getting an execution plan including fetching rows, you can now limit the total number of rows fetched and the number of rows fetched per DB fetch call. This can help generate realistic executions plans without having to fetch all result rows:
  • Fixed the AWR/SP reports delta calculations for overflowing values and SQL address changes
  • AWR/SP SQL reports: There is now an option to sum up values/counts from different SQL_IDs with the same FORCE_MATCHING_SIGNATURE hash under one SQL_ID:
  • AWR/SP SQL reports: You can now set the minimum number of Top SQL statements shown in the report (see image above)
  • AWR/SP SQL reports: Added context menu for SQL series with actions for the SQL_ID under the cursor:
  • AWR/SP SQL reports: Added context menu action to show the unaggregated data from STATS$SQL_SUMMARY / DBA_HIST_SQLSTAT
  • AWR/SP SQL reports: Added “Locate SQL_ID” dialog that makes an SQL_ID visible in all charts, optionally including all SQL_ID which are above a custom correlation value:
  • AWR/SP reports: Added SGA and PGA Statistics report

  • Added SQL keyword proposals in console window (press CTRL+Space to trigger – you can add your own keywords to the …\config\keywords_user.txt file):
    Keywords are currently from Oracle 11.2, but I plan to add a feature that lets you fetch the keywords from your database and link the generated keyword file to a connection set up in Mumbai.
  • You can now define snippets in the custom scripts dialog and use them from the SQL keyword proposals selector in the console window:
  • Show execution plan context menu action on SQL_ID and CHILD_NUMBER columns now correctly observes the content of the CHILD_NUMBER column
  • Added context menu actions for “Show compilation environment” and “Show reasons for non shared cursor” (when SQL_ID and CHILD_NUMBER columns are available)
  • Added mouse wheel scrolling for card views (as seen in the database info view)
  • Added database info view (consolidating V$DATABASE, V$INSTANCE, V$VERSION and V$DATABASE_INCARNATION)
  • Added view for V$SQL_BIND_CAPTURE (including a handy context menu action which opens the selected SQL including the bind variable definitions in a console window)
  • Added an editor macro recorder in the console window
  • Fixed the “Missing bind variables” view which also showed child cursors for the same sql_id
  • “Find object” now lets you search by OBJECT_ID
  • You can now select a color/bold font style for the tabs in main window through the context menu for the tabs:
  • You can now select the sources for SP/AWR correlations: