What is Mumbai?

Mumbai is a freeware Windows application targeted at Oracle DBAs and consultants, with a special focus on performance analysis.


Mumbai was tested on Windows XP, 2003 and Windows 7 and might well work on other versions of Windows. Mumbai needs a full Oracle Client installed on the machine where it runs or an Oracle Instant Client which needs to be available in a directory listed in the PATH environment variable.

Mumbai is meant to work with Oracle databases 9.2 to 11.2, but was mainly tested on 10.2. Some functionality is not available for 9.2 databases.


  • 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


Besides the screenshots below, there is a 30-minute webcast available showing what Mumbai can do.

Main interface and System events view showing how you can slice queried data in Mumbai

Visualized Time Model Data from a snapper session

Execution plan generated with DBMS_XPLAN including execution statistics

Mumbai's 10046 trace file viewer


70 Responses to Mumbai

  1. Pingback: First public release of Mumbai | Marcus Mönnig's Oracle and Mumbai Blog

  2. John says:


    What a very nice utility you’ve developed. Thank you very much for sharing it.

    I have not used it much (yet) but, it is truly a utility its developer should be proud of 😉

    Thanks again,


  3. Yunus Emre says:

    Good Job. i see u in OTN.

    i come here for see what u got. You suprised me.

    Really good Job.

    Btw why your program dosnt have something like this : Handfull Script library, i wish program got something like that.

    • mamoennig says:

      I’m not exactly sure if you understand what you mean. Would you like to be able to define your own scripts or do you expect the application to come with (more) pre-defined scripts?

  4. karlarao says:

    Hi Marcus,

    Good job! 🙂 I’ll definitely add this to my list of “must have” database tools

  5. max says:

    Great job Marcus, But had a question for you. When i run snapper and if i go in Time model chart or wait events chart. It seems like the column always goes in negative ?? i mean any they show upside down….its happens when i run snapper….here is the link to a screenshot that i am talking about…

    please advise

    • Can you drop me line by at mm at symbol I would need to have the spool files that the snapper script creates to look into it.

    • This is most likely a problem with parsing the format returned by the snapper script.

      Either download the current version of Mumbai where the snapper script is included and configured correctly or make sure that in your current Mumbai installation the parameters

      output_delta number := 0; — raw delta

      output_hdelta number := 1; — human readable delta

      are changed to

      output_delta number := 1; — raw delta

      output_hdelta number := 0; — human readable delta

      in the file …Mumbai\3rdparty\snapper\snapper.sql.

  6. max says:

    Hi Marcus, Thank you for the follow up. Looks like changing that setting you mentioned work for me. Appreciate it.

    And also, GREAT JOB and more than great job May GOD bless you and your family for sharing such a wonderful tool for free. Not a lot of people do that. People with high/Advance level knowledge makes there own scripts/tools but do not give it out like this. Kudos to you and Tanel.

  7. Guy Shilo says:

    Hello Marcus

    I just started to play around with Mumbai and it seems like a great tool for the “DBA on the go”. Of course I have now a kind of a “wish list” of feature I wish will be included in next versions.
    I understand this is a personal project and not an open source effort, but is there a way to get involved ? to help this tool develop ? or even to post my wishlist ?

    Thanks, and keep up the great job


  8. Hello Guy,

    feel free to post your wishlist as a comment here.

    Regarding help to develop, well, there is no API or plug-in interface, so I currently see no way to do it.


  9. Guy Shilo says:

    Hi again

    Well, Mumbai can, in many ways, be a DBA’s one stop shop that has everything you need (in case your’e on the go and don’t have acces to bigger and expensive tools such as TOAD).
    Only thing is that it needs a stronger support for custom scripts. That means mainly hierarchy support – folders. In current situation, if you add more than dozen of custom scripts it becomes very hard to handle. Enabling folders and sub folders will make it possible to enter all your script library to mumbai.
    Of course, a form for adding/deleting/editing scripts is also desireable.
    Im not sure thats what you want your application to become (some kind of a script framework with few built-in tools), but I hope you can add this in the future.


    • Thanks for your comments! I agree that stronger support for custom scripts would make a lot of sense. I’ll think about how to implement this…

      • Guy Shilo says:


        I think a good way to go ill be to replace the commands.ini file with an XML file. That would enable hierarchy.


  10. Andre van Winssen says:

    on windows 7 I had to run mumbai “as Administrator” otherwise the snapping failed on not being able to create the c:\out.txt file. Great tool!

  11. Hi Markus,

    Supertool – echt genial. Werde es mir genauer anschauen und weiterempfehlen – auch bei Schulungen!

    Kleine Frage am Rande: Welche Sprache/Framework hast Du verwendet? Sie echt toll aus!!



  12. Hallo Felix,

    schön dass es gefällt!
    Mubai ist mit Delphi und dort insbesondere mit den Komponenten von DeveloperExpress geschrieben.


  13. Christian Antognini says:

    Hi Marcus

    Thank you very much for sharing your work! I’ll give it a try…


  14. KS says:

    Does this wonderful application works with 64 Bit Oracle client ?
    As it gives me error:
    Make sure you have 32 bit Oracle Client Installed

  15. Abhishek H says:

    Hi Marcus,
    Seems like a useful tool. Will give it a try.
    I have a question: Why did you name it ‘Mumbai’ ?


  16. Martin says:

    Hi Marcus, whew, what a nice tool, excellent job (and I wonder how You managed to develop it during Your job at W.). Nevertheless while I played around just testing some of the features, I found that in the – I mean really odd – situation where there will be hundreds – no; I’ll be honest: 32 – of redo log groups, Mumbai just presents an ora-01722: invalid number with no data displayed in the chart. (but don’t blame me on that silly (for me) amount of defined groups, blame the dba instead 🙂 )

    greetings from Barmbek,


    • Hey Martin!

      Which query/view are you referring to? Files > Log groups/files/switch?

      Greetings from St. Pauli,

      • Martin says:

        yep – I will send You a bugreport generated out of Mumbai, might be helpfull – problem may be caused by RAC-connection, but error occurs even when not connected load balanced (e.g. single instance)

      • Actually, I don’t need it any more, since I fixed it already for the next release. Happens when there were more than 99 log file switches per hour.

      • Martin says:

        oki, I thought about something like that – I really don’t know why they configured that thing in this way; having a log switch every 45 secs. Well, whoever needs this 🙂

      • If they have 32 redo log groups and log switches every 45 seconds it looks like they tried to lower the log switch rate by adding more groups, while in fact they should have resized the redo log files, so that a log switch doesn’t happen so often.

      • Martin says:

        yep – but some will allways be resistent to consulting 😦

  17. Arun says:

    I got some errors while installing/starting the tool.

  18. Deano says:

    Marcus – simply put, this is an excellent program! My colleagues and I support numerous customer systems and this has will make this even easier. Thankyou for providing it for free!

  19. Ed says:

    Hi Marcus,
    Trying out Mumbai. At the moment, it looks very, very good. Using Files – Tablespaces is taking a long time though. I let it run for 60 minutes hoping it will come up with something, but no such luck.

    Not sure if it has to do with the fact that the database that am trying it on is 3TB with 5000+ datafiles. Toad is not complaining though.

    Any advice on how to get around this problem? FYI, database is Oracle running on Solaris

    • I know the problem with averages, but an average datafile size of 629MB sounds pretty small. Out of interest, what is the rationale for so many little files.

      It has probably to do with the large number of files. I’ll look into that.

    • I tested this with 5000 datafiles in five tablespace and I don’t see a problem. How many tablespaces do you have?

  20. Mitch says:

    Can this be run on 64 bit WINDOWS 7 client, it seems the answer=no

  21. Gerrit Haase says:

    Nett, I like it.
    Since there is BASH on the next page, I wonder if there will be ASH integration in Mumbai?

    • Yes, I’ve already implemented an ASH view and I’m in the process of testing it against data collected with BASH. It basically looks like ASH Viewer or what Enterprise Manager shows, but with a few more possibilities for filtering and grouping and some context menues to quickly jump to other views.

  22. Vikram Rathour says:

    Great Tool Marcus. I assume this tool does not need Oracle Diagnostic and Tuning Packs?

  23. Robert says:


    I have a reproduceable issue with mumbai where it hangs each time. Where to send the bugreport to?


  24. Robert says:

    Each time I press the refresh button in the Statspack tab the programm starts to hang and a minute later or so the bugreport dialog pops up.

  25. Bheem says:


    I have a Windows 7, 64-bit machine with 32-bit oracle full client. My sqlplus works, but when I invoke Mumbai using TNS connection, I am getting the “ORA-12154: TNS could not resolve the connect identifier specified” error. What could be the problem?


  26. hepeng says:

    Hello, Marcus
    i click refresh on awr viewer , but the mumbai is hang.
    exception message : The application seems to be frozen.
    What is the problem, please?

  27. Hello Marcus,

    I sent you a few months ago a question regarding the issue when we try to read large amount of “AWR” data and we get “out of memory” error.

    Did you received my email and do you think it is “solvable” ? Would be awesome to be able to graph more data from AWR and go above 1G limit of the tool.


    • Marcus says:

      I am again working on Mumbai and there should be a new version out within the next two months. This will include a 64-bit build that should help with large amounts of data being fetched.

  28. Robert says:

    Hello Marcus,

    the mumbai tool crashed when running it over a very long ash period with an out of memory exception. Can you do something? Shall I provide you the crash dump?

  29. Imran says:

    Can we please have a MAC version ?

  30. Mir Ali says:

    Hi Marcus,

    I’ve a 64-bit windows 7 OS. I get the error below,

    Initialization error.

    Make sure you have the 32 bits Oracle Client Installed.


    • Marcus says:

      Hi Mir,

      since Mumbai is a 32-bit application, it needs a 32-bit Oracle client. You will need to install the 32-bit client in addition to your existing 64-bit client to use Mumbai.


      • Mir Ali says:


        Thank you very much for replying back. The tools looks great. Can’t wait to use it.

        I thought in one of your replies you said you were working on getting it to work in 64 bit OS also. I just was making sure I didn’t miss anything.

        Thanks again, Mir


      • Marcus says:

        I’ve tested the 64bit version over the last weeks and it should be available soon.

  31. Dusan says:

    Hi Marcus,

    I’ve tried the Mumbai for the first time for implementing purposes where EM is not an option, it is an excellent tool with very good performances and have set it up in minutes, since i would like to dig more deeply into Mumbai do you have any documentation regarding it, like user manual or administration guide ?

    Thanks in advance,

  32. desco says:

    Brilliant !

  33. Baljit Singh says:

    Hello Support,

    Please let me know that can we send email notification alerts with this tool


  34. Hallo Marcus,

    vielen Dank für die Entwicklung und Bereitstellung von Mumbai und insbesondere BASH! Ein großartiges Werkzeug dessen nützlichen Funktionen ich immer mehr zu schätzen weiß.


  35. Hello Marcus,

    Have you thought to add support for SQL monitoring in future release, it would be really useful (for people having the licence of course).

    I use Mumbai on a daily basis, this is really an awesome tool.


  36. Pingback: mystery performance issue with background process – Benjamin Kurschies – just another oracle nerd

  37. Robert says:

    Hi Marcus,

    are you actually further developing mumbai? It is a great tool but more and more runs into access violations while trying to visualize ASH data (same with BASH data as well). I am starting to think about other tools for that purpose but I don’t want to ;-).


Leave a Reply to Marcus Mönnig Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s