Mumbai version 1.1.1.331

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

  • There are now three grouping options for Snapper available: “sql_id+event+wait_class”, “sid+sql_hash_value+event”, “sid+sql_id”
  • Console output window now uses a fixed font
  • Added object_type search criteria in object search dialog
  • Added support for DBMS_OUTPUT in the console window
  • Added “log groups/files/switch map” view
  • Added “Show ddl” context menu items for jobs and scheduler jobs
  • Added dba_scheduler_schedules view
  • DDL lookups for V_$* and GV_$* views are now served by a lookup in V$fixed_view_definition
  • Added “Search SQL text by sql_id” function (searches V$SQLTEXT, DBA_HIST_SQLTEXT (if Diagnostic Pack is licensed) and PERFSTAT.STATS$SQLTEXT (index on column sql_id is recommended))
  • Tabs in the main window can now be moved by drag & drop
  • Fixed order of values in one of the Statspack/AWR instance activity diagrams
  • Closing the snapper window somtimes left the Snapper SQL*Plus session open
  • DDL shown from the context menu of the object view disappared when closing the object view
  • When “count records” was disabled in the console window, executing a query always fetched all records
  • Fixed an out of memory error when loading a 10046 trace file
This entry was posted in Mumbai. Bookmark the permalink.

6 Responses to Mumbai version 1.1.1.331

  1. Noons says:

    Hi Marcus.
    Just upgraded and can’t see my multiple statspack schemas.
    Not the “table or view does not exist” problem I had before.
    Simply, the Statspack tab doesn’t show any active dropdowns for Instance, Start and End.
    The connection I was using it with before works fine, but any other connection for other schemas doesn’t.
    I wonder what’s ticking?

  2. Noons says:

    Found out what the problem was, please ignore previous post.
    I simply forgot to grant SELECT_CATALOG_ROLE to all the different schemas.

  3. Noons says:

    Sorry to be a pest, Marcus. But I reckon you’d appreciate the feedback.

    I’m doing medium and long term analysis of our stats, looking for trends and so on.

    Some of the stats I like to analyze over a period are the I/O ones: total physical read and written bytes, In our case the numbers are enormous, exceeding TBs in each sampling period of 4 hours. I’m getting errors when looking at them – the error dialogue seems to imply that there is an overflow error in conversion to integer.
    The exception message says: Overflow while converting variant of type (Double) into type (Integer).The call stack:
    date/time : 2011-08-31, 08:14:03, 69ms
    computer name : ommited
    user name : ommited
    registered owner : ommited
    operating system : Windows XP Service Pack 3 build 2600
    system language : English
    system up time : 7 days 23 hours
    program up time : 14 minutes 11 seconds
    processors : 2x Intel(R) Core(TM)2 Duo CPU E8600 @ 3.33GHz
    physical memory : 2368/3579 MB (free/total)
    free disk space : (C:) 441.47 GB (J:) 446.18 GB
    display mode : 1920×1200, 32 bit
    process id : $1338
    allocated memory : 62.03 MB
    executable : Mumbai.exe
    exec. date/time : 2011-08-17 19:42
    version : 1.1.1.331
    compiled with : Delphi 2010
    madExcept version : 3.0l
    callstack crc : $59671ba6, $3732fab8, $a35e726e
    exception number : 3
    exception class : EVariantOverflowError
    exception message : Overflow while converting variant of type (Double) into type (Integer).

    main thread ($3bc):
    00480abf +06f Mumbai.exe Variants VarOverflowError
    00480dc5 +025 Mumbai.exe Variants VarResultCheck
    00480df7 +023 Mumbai.exe Variants HandleConversionException
    004822fc +490 Mumbai.exe Variants @VarToInteger
    00dbaa43 +0af Mumbai.exe cxGridChartView 9216 +8 TcxGridChartHistogramViewInfo.GetValueOffset
    00dbcf1b +03f Mumbai.exe cxGridChartView 10500 +1 TcxGridChartLineDiagramViewInfo.GetValueY
    00dbd03f +047 Mumbai.exe cxGridChartView 10532 +5 TcxGridChartLineDiagramViewInfo.CalculateValues
    008adb53 +02b Mumbai.exe cxGridCustomView 5740 +1 TcxCustomGridCellViewInfo.Calculate
    00dbb75e +0ee Mumbai.exe cxGridChartView 9652 +17 TcxGridChartHistogramViewInfo.Calculate
    00dbfd24 +03c Mumbai.exe cxGridChartView 12345 +5 TcxGridChartViewInfo.Calculate
    008aee38 +064 Mumbai.exe cxGridCustomView 6538 +12 TcxCustomGridViewInfo.MainCalculate
    00860ddf +04f Mumbai.exe cxGrid 653 +6 TcxGridLayoutChange.Execute
    00863235 +035 Mumbai.exe cxGrid 2010 +6 TcxCustomGrid.DoChange
    0086347a +082 Mumbai.exe cxGrid 2115 +14 DoFinalChanges
    00863501 +031 Mumbai.exe cxGrid 2132 +4 TcxCustomGrid.DoUpdate
    00863792 +01e Mumbai.exe cxGrid 2262 +3 TcxCustomGrid.EndUpdate
    008b19c0 +08c Mumbai.exe cxGridCustomView 8265 +14 TcxCustomGridView.EndUpdate
    008b1aab +07b Mumbai.exe cxGridCustomView 8306 +12 TcxCustomGridView.Changed
    00dc35e8 +008 Mumbai.exe cxGridChartView 14948 +1 TcxGridChartItem.Changed
    00dc3362 +01e Mumbai.exe cxGridChartView 14871 +5 TcxGridChartItem.SetVisible
    00db2612 +036 Mumbai.exe cxGridChartView 4784 +3 TcxGridChartSeriesCheckListBox.CheckClicked
    007f1ce1 +02d Mumbai.exe cxCheckListBox 1308 +2 TcxCustomInnerCheckListBox.DoClickCheck
    007f1ca9 +0c1 Mumbai.exe cxCheckListBox 1301 +20 TcxCustomInnerCheckListBox.ToggleClickCheck
    007f1a43 +063 Mumbai.exe cxCheckListBox 1225 +9 TcxCustomInnerCheckListBox.MouseDown
    0053d3b8 +08c Mumbai.exe Controls TControl.DoMouseDown
    0053d407 +03f Mumbai.exe Controls TControl.WMLButtonDown
    004e0a59 +081 Mumbai.exe StdCtrls TCustomListBox.WMLButtonDown
    005bc333 +03f Mumbai.exe cxContainer 6018 +4 TcxCustomInnerListBox.WMLButtonDown
    007f135e +09a Mumbai.exe cxCheckListBox 1008 +11 TcxCustomInnerCheckListBox.WMLButtonDown
    004e0932 +05a Mumbai.exe StdCtrls TCustomListBox.WndProc
    005bbf45 +025 Mumbai.exe cxContainer 5857 +3 TcxCustomInnerListBox.WndProc
    007f18a6 +00a Mumbai.exe cxCheckListBox 1149 +1 TcxCustomInnerCheckListBox.WndProc
    00540cc8 +02c Mumbai.exe Controls TWinControl.MainWndProc
    004a8894 +014 Mumbai.exe Classes StdWndProc
    7e418a0b +00a USER32.dll DispatchMessageW
    0056c745 +11d Mumbai.exe Forms TApplication.ProcessMessage
    0056c78a +00a Mumbai.exe Forms TApplication.HandleMessage
    0056cab5 +0c9 Mumbai.exe Forms TApplication.Run
    00f8efcd +061 Mumbai.exe Mumbai 99 +5 initialization

    thread $17b8:
    7c90df48 +0a ntdll.dll NtWaitForMultipleObjects
    7c80958a +00 kernel32.dll WaitForMultipleObjectsEx
    7c80a110 +13 kernel32.dll WaitForMultipleObjects
    00466179 +0d Mumbai.exe madExcept CallThreadProcSafe
    004661e3 +37 Mumbai.exe madExcept ThreadExceptFrame
    >> created by main thread ($3bc) at:
    72d2328c +00 wdmaud.drv

    thread $14cc:
    7e427766 +3b USER32.dll GetMessageA
    00466179 +0d Mumbai.exe madExcept CallThreadProcSafe
    004661e3 +37 Mumbai.exe madExcept ThreadExceptFrame
    >> created by main thread ($3bc) at:
    76b45e9f +00 winmm.dll

    thread $a90:
    7c90d218 +0a ntdll.dll NtDelayExecution
    7c8023eb +4b kernel32.dll SleepEx
    7c802450 +0a kernel32.dll Sleep
    00dddcd2 +8a Mumbai.exe cxShellCommon 1354 +16 cxShellItemsInfoGathererFetchThreadFunction
    00466179 +0d Mumbai.exe madExcept CallThreadProcSafe
    004661e3 +37 Mumbai.exe madExcept ThreadExceptFrame
    >> created by main thread ($3bc) at:
    00ddf1cd +41 Mumbai.exe cxShellCommon 2076 +4 TcxShellItemsInfoGatherer.CreateFetchThread

    thread $a0c:
    7c90d218 +0a ntdll.dll NtDelayExecution
    7c8023eb +4b kernel32.dll SleepEx
    7c802450 +0a kernel32.dll Sleep
    00dddcd2 +8a Mumbai.exe cxShellCommon 1354 +16 cxShellItemsInfoGathererFetchThreadFunction
    00466179 +0d Mumbai.exe madExcept CallThreadProcSafe
    004661e3 +37 Mumbai.exe madExcept ThreadExceptFrame
    >> created by main thread ($3bc) at:
    00ddf1cd +41 Mumbai.exe cxShellCommon 2076 +4 TcxShellItemsInfoGatherer.CreateFetchThread

    modules:
    00400000 Mumbai.exe 1.1.1.331 J:\Downloads\DB
    057d0000 oraslax10.dll 10.2.0.1 C:\oracle\product\10.2.0\client_1\bin
    06fe0000 GrooveIntlResource.dll 14.0.6009.1000 C:\PROGRA~1\MICROS~2\Office14\1033
    078c0000 oci.dll 10.2.0.1 C:\oracle\product\10.2.0\client_1\bin
    07920000 MSVCIRT.dll 7.0.2600.5512 C:\WINDOWS\system32
    07a70000 oracommon10.dll 10.2.0.1 C:\oracle\product\10.2.0\client_1\bin
    07b70000 orageneric10.dll 10.2.0.1 C:\oracle\product\10.2.0\client_1\bin
    080d0000 oraxml10.dll 10.2.0.1 C:\oracle\product\10.2.0\client_1\bin
    08230000 orasql10.dll 10.2.0.1 C:\oracle\product\10.2.0\client_1\bin

    etcetc. If you want the entire dump, let me know which email to send it to.

    • Are you getting this when showing/hiding a series in one of the chart views?
      I’ve seen this myself and the workaround is to hide the series again that triggered the error, then close the error window, then enable another series (that hopefully doesn’t trigger the error), then enable the series that you actually want to see and finally hide the series again that you don’t want… A bit of a pain, but the problem is not in my code, but in 3rd party code, so it’s not easy to fix on my side and hard to reproduce.

  4. Noons says:

    Yes, exactly: when showing/hiding a series. Yeah, the going out and in again seems to fix it, thanks.
    Will be eagerly waiting for the next release, this tool is turning into a life-saver for me: a lot faster to get the graphics this way than through Excel sheets with embedded custom SQL. Thanks a lot for making it available.

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