Mumbai now with support for AWR


Besides a couple of bug fixes the new version of Mumbai brings support for AWR (Automatic Workload Repository). Additionally, to the table and chart views that are also there for Statspack data (parameter changes, instance activity, wait events, time model statistics and OS stats), for AWR you can directly generate and view instance, compare period and SQL reports in text or html format.

Please respect the Oracle licensing rules. For using AWR, you need to license the Oracle Diagnostic Pack.

This entry was posted in Mumbai. Bookmark the permalink.

3 Responses to Mumbai now with support for AWR

  1. Kevin Fries says:

    Dumb question. I’ve installed this on a 64 bit windows box without the explicit Instant Client for 11g. When I try to make the connection it complains that it wants the 32 bit libraries. So I’m confused as to whether it requires a 32 bit Instant Client or I’ve got the wrong path set up. This is my personal laptop and the database is planned to be used for a variety of things I dare not do elsewhere on customer boxes for performance testing and also to test customer boxes in a non-intrusive manner.

    I did see something on the web about the path it expects to find for the client libraries, darned if I can find it now, so I’m not sure if I can change it or do something different. No rush on a reply but feel free to ask about whatever I’ve left out of this.

    As you can see, it’s not the usual /oracle// so there’s a bit of flexibility allowed.

    C:\Users\kfries>path
    PATH=C:\app\kfries\product\11.2.0\dbhome_1\bin;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\
    Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\
    System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE
    \Core-Static;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Prog
    ram Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Comm
    on Files\Roxio Shared\12.0\DLLShared\;C:\Program Files (x86)\Windows Live\Shared
    ;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\IDM
    Computer Solutions\UltraEdit\;C:\Program Files (x86)\IDM Computer Solutions\Ult
    raCompare\

    C:\Users\kfries>

    • Hello Kevin,

      Mumbai is a 32-bit application and it will need a 32-bit client. If you need to have another client or database home installed on this machine that is 64-bit, just make sure that the PATH variable references the 32-bit client when starting Mumbai, e.g. you could create a Mumbai.bat file with the content:

      set PATH=;%PATH%
      Mumbai.exe

      HTH,
      Marcus

      • Kevin Fries says:

        That seemed to work. Thank you for your clarification on the 32-bit client. I’ll need to do a bit more on the batch file since it seems necessary to restore the path when it’s finished.

        Probably something like
        set path1=%PATH%
        set path=c:Instcli32;%PATH%
        mumbai.exe
        set path=%PATH1%

        I’m playing with it for now and it seems happy. Now it’s on to some real performance problems from work next. Star schema queries from an SAP system are always fun. It always could be worse, it could be DB2 LUW or SQL Squealer are the other DBs and their optimizers are nightmares.
        Thanks again for the quick response.

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