While I still want to test a few things before I release a new version of Mumbai, below is already a list of features and bug fixes that I have been working on over the last weeks and months.
- Added graphical execution plan visualization
- Execution plans are now shown with additional columns as seen in Randolf Geist’s brilliant xplan_extended_display_cursor script (http://oracle-randolf.blogspot.com/2011/12/extended-displaycursor-with-rowsource.html) – Kudos and big thanks to Randolf!
- Added correlation report for SP/AWR data
- Made the SP/AWR SQL report queries significantly faster
- Added Elapsed time, CPU time, Buffer gets and Disk reads per execution graphs in SP/AWR SQL reports
- Added “Disk reads” graph to Statspack/AWR SQL reports
- Fixed a problem in the “Elapsed time” graph for SP/AWR data showing unrealistic high values
- Fixed error message in the log file switch map for more than 99 log file switches per hour
- Joined the info from DBA_JOBS_RUNNING and DBA_JOBS into one view
- Added “Base table” column in Segments View
- Three new grouping options for Snapper ASH mode are available: “sid+sql_hash_value+event+program”, “sid+sql_hash_value+event+module”, “sid+sql_hash_value+event+terminal”
- In the snapper ASH diagram you can now actually group by all columns that you asked snapper to gather
- Added “Export to png” for chart views (in the “Data shown” tab of the customization window)
- Updated Orasrp fixing a problem with empty 10046 trace file reports
- Added “Show user ddl” context menu items in the user view
- “Search SQL text by sql_id” now searches in V$SQLTEXT_WITH_NEWLINES
- Fixed fetched record count in the status bar of the console window showing “?”
I am especially excited about the new graphical execution plan feature, the execution plans on steroids based on Randolf Geist’s terrific xplan_extended_display_cursor script and the correlation report for SP/AWR data.
I’ll post more about these features and how to use them in Mumbai over the next days.