Mumbai

What is Mumbai?

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

Prerequisites

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.

Features

  • 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

Screenshots

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

 

51 Responses to Mumbai

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

  2. John says:

    Marcus,

    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,

    John.

  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 http://karlarao.tiddlyspot.com/#PerformanceTools-Database

  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…
    http://www.freeimagehosting.net/image.php?72cb7fe264.png

    please advise

    • Can you drop me line by at mm at symbol marcusmoennig.de? 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

    Guy

  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.

    Cheers,
    Marcus

  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.

    Cheers
    Guy

    • 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:

        Hi

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

        Thanks
        Guy

  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!!

    Gruß

    Felix

  12. Hallo Felix,

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

    Marcus

  13. Christian Antognini says:

    Hi Marcus

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

    Cheers,
    Chris

  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’ ?

    /Abhishek

  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,

    Martin

    • Hey Martin!

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

      Greetings from St. Pauli,
      Marcus

      • 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:

    Hi,
    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 10.2.0.5 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:

    Hi,

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

    Regards,
    Robert

  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:

    Marcus,

    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?

    Thanks
    BA

  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?

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s