Welcome to the world of BIG performance data
Method R Workbench 9 is the culmination of a vision years in the making. It’s the world’s first Oracle trace file management system. Here are some of the highlights:
- Know more, earlier. The first change you’ll notice is the new CPU, LIOs, PIOs, RTs, and Rows columns in the files pane—all sortable. These make it easier for you to know which trace file to drill into first.
- Read your trace files like a book. Significant improvements to the English narrative in the Method R Profile reports make it easier than ever to understand the stories that your trace files are trying to tell you.
- Find what you need. The all-new mrcrop utility helps you isolate the trace data for your individual user experiences, even if your application is difficult to trace—because of connection pooling, multiplexing, parallel processing, no use of user session handle attributes, or whatever. Instead of worrying about laser-precision tracing, now you can trace your whole database for a few hours and then fish out the details you care about. It’s fast, even if you’re working with thousands of trace files.
- Know when it happened. The all-new mrwhen utility makes it easy to see exactly when something happened in a trace file. This makes your trace data directly relatable to your users’ experiences, and to your other diagnostic tools.
- Fast. So you can cope with thousands of files. The mrskew and mrls utilities are 10–20× faster than before. And we’ve multi-threaded our already ridiculously fast profiler, which means the Workbench can gobble trace files at an incredible pace. These things make a huge difference: faster software means faster progress. Besides, faster is just way more fun.
Here’s the thing:
Trace files give you incredibly rich, high-resolution performance information, but tracing creates so… much… data. You can’t possibly manage it all without great tools.
Method R Workbench 9 makes working with trace data quick and easy, even if you’re staring down thousands of trace files.
Let us open your eyes to a new world, a world in which you can see where all your application’s time is going.
Here are the cases we’ve implemented in Method R Workbench 9:
- 8071: Rearranged the mrskew manual page to make the packaged .rc files section easier to find.
- 8067: Fixed a bug causing the Workbench application not to check for updates upon startup in cases when it should.
- 8066: The Workbench application for Microsoft Windows now resists accidental concurrent instantiations of the same version.
- 8063: New mr1011 utility converts Oracle Database version 10.2 trace files into version 11.1 format, which enables Method R Workbench to process 10gR2 trace files.
- 8060: mrprof now processes all data in a multi-session trace file; the
--ignore-multiple-sessions-fileoptions have been eliminated.
- 8059: New column names and tool tips in the files pane make it easier to understand your data.
- 8054: Added new mrwhen reports to the actions pane.
- 8053: mrprof now writes output printed by the
--traceoption to a file called
- 8046: Fixed a bug causing Workbench not to open the output HTML file when using the mrprof
- 8044: Major advisory text improvements throughout the Method R Profile report.
- 8041: Fixed a bug that caused the Workbench application to make too many check-for-updates calls.
- 8038: Added “RTs” column, which shows the file’s network round-trip count.
- 8025: Workbench on macOS now automatically detects both JRE 8 and JDK 8.
- 8021: Workbench now writes the Java home directory and version number information into the application log file.
- 8016: Optimized mrprof memory allocation for cases in which the input trace file has many thousands of distinct SQL texts.
- 8013: Fixed a bug where mrprof would fail to record why it could not load an extremely large XML file.
- 8000: Workbench now uses parallel execution to load trace files into the files panel. This reduces file load response times on multi-core systems. The degree of parallelism is configurable in .
- 7995: Renamed “Report Parameters” dialog to “Action Parameters”.
- 7994: Field labels in the Action Parameters dialog now use sentence case.
- 7992: Made cosmetic improvements to the “Action Parameters” dialog.
- 7990: Eliminated the “Details by file” action, which has been replaced by the faster and higher-precision “Copy selected file rows to output” button.
- 7988: Alphabetized the action name list in the application’s actions pane.
- 7987: The “Action Parameters” dialog now has field hints to help with more complicated input formats.
- 7985: Created new manual page for mrworkbench, which includes JRE troubleshooting advice.
- 7983: “Action Parameters” dialog now remembers the most recent value you’ve used for each parameter during a given invocation of Method R Workbench.
- 7974: Removed the unimplemented
--compression-formatsoption from the mrprof man page.
- 7969: Fixed a bug that can cause mrprof to re-profile input files more often than necessary.
- 7954: mrprof now makes it easier to see hierarchical relationships in Profile by Cursor and Execution Plan sections, by using numbers instead of dots to denote hierarchy levels.
- 7952: Fixed a bug that would cause mrprof to print all the execution plans for a given statement in each section 4.*.5.*, instead of just one plan per section.
- 7946: Removed “can’t evaluate” message explanation from the Exit Status section of the mrskew man page. This message no longer applies to the newly rewritten mrskew utility.
- 7938: Changed mrprof
%b(because it represents the file base name), which is consistent with the syntax of the new mrcrop utility.
- 7934: Fixed a bug that in which mrprof could die instead of issuing a warning.
- 7932: New option replaces the old and less useful option.
- 7908: References to undefined variables formerly caused mrskew to emit an error and die. Now, the value of an undefined variable reference is the empty string, and mrskew will not throw an error.
- 7906: Advisory text now contains hyperlinks directly to Method R Workbench utilities manual pages and the Mastering Oracle Trace Data book.
- 7902: Fixed an HTML validation error.
- 7901: Added execution count to the Profile by Cursor section.
- 7899: Added execution count to the Profile by Caller sections.
- 7898: Added execution count to the Profile by Statement sections.
- 7892: mrtimfix is now obsolete and no longer shipped. mrtimfix was useful only for systems prior to Oracle Database 11.1 (which we no longer support), and 11.1 systems suffering from Oracle bug 7522002 (which was patched long ago).
- 7891: mrtim is now obsolete and no longer shipped. It is replaced with the much more useful mrwhen.
- 7886: A new horizontal scroll bar makes it easier to use all the new columns in the application’s files pane.
- 7883: Documented how mrskew uses the
- 7870: Renamed mrskew
- 7860: New mrskew
$dir_namevariables make it faster and easier to reference parts of a file name.
- 7851: Created a manual page for mrprofk.
- 7838: Improved the advisory text in the Profile report for synthetic calls, and improved Synthetic Calls documentation in the mrprof manual page.
- 7833: Eliminated the
--eulaoption. Users can find the license agreement information in each utility’s manual page.
- 7828: Standardized the processing of options used by every utility. Now,
--versionall behave consistently, and command line errors are processed consistently across utilities.
- 7813: Fixed a bug that would spin the application’s “Processing” busy indicator forever when a command line option’s quotes don’t match.
- 7803: Removed mrskew
--trcunitoptions and the
- 7801: Documented the mrskew
- 7800: mrskew is now more 10–20× faster than before.
- 7799: Consolidated and simplified error reporting for
.rcfile names not found.
- 7798: Deprecated mrskew
--rc=mrnl.rc. To see when calls begin and end, use the new mrwhen utility.
- 7796: Changed the XML schema for reports.xml so that now label is an attribute of the diagnostic element (instead of a child element).
- 7788: Method R Workbench now uses LaTeX to render more beautiful PDF manual pages.
- 7784: Moved mrls
END-TIMcolumns to a more logical place in the output.
- 7782: mrls
--debugoption now writes debugging information to
- 7781: Renamed mrls
- 7780: New mrls
--tags-dbfileoption allows you to specify which SQLite database to use for retrieval of
- 7777: New mrls
--exclude=:alloptions obviate the old
- 7775: Added new mrls
- 7774: Replaced the old mrls options like
--nocpufor including and excluding columns with new
- 7772: The mrls
--sortoption now takes a column heading (e.g.,
VERSION, etc.) as its argument.
- 7763: mrls now dies if you use
--sorton a field and then exclude that field from the output.
- 7762: mrls is now more than 20× faster than before.
- 7759: Deprecated the mrls
--scanmaxoption; to request full-precision output, use
--include=DEPor any of the other columns that force mrls to read the entire input file.
- 7755: Reduced the size of the distribution by storing the sqlite3 load library in the distribution’s file system instead of the sqlite jar file.
- 7752: Made significant, sweeping changes to mrls column display interface and manual page.
- 7746: mrls now displays “?” instead of negative number for unknown recursive depth values.
- 7739: mrls no longer uses a complicated algorithm based on the file’s modification time to try to guess the
STARTvalue for a file. Now it simply warns when there is no timestamp in the input trace file.
- 7737: Removed under-utilized mrls options:
- 7722: Now you can use
mrls -ras an alias for
- 7719: Documented in mrprof man page that mrprof works only with extended SQL trace files generated by Oracle Database 11.1 and newer.
- 7718: Fixed a bug that would cause a mrprof command line execution to fail if the Method R Workbench application had not yet been opened since the most recent installation or upgrade.
- 7695: Fixed a bug where starting the app might result in the window not being visible.
- 7692: Fixed a bug that could cause a file to have duplicate rows in the files pane.
- 7688: Fixed a mrprof bug that could cause a statement to be identified as “MRPROF-ERROR-0004” in the Profile by Cursor section.
- 7683: New, simpler application “Show Details” button image.
- 7678: Method R Workbench 9 is certified to run on macOS 10.15 Catalina.
- 7674: New
-R) option gives you control over whether mrprof plunges into the directories it finds.
- 7654: New application sortable ID column lets you sort files in the order they will be processed by the automatic profiler.
- 7653: Fixed a bug that could cause the “Copy selected file rows to output” button not to write information into the output pane.
- 7648: Changed status bar labeling from “filtered” to “hidden” on files pane and actions pane.
- 7635: mrskew now reports the list of files that matched the
- 7630: Fixed a bug that caused mrskew to calculate
$ssqlidincorrectly when a “***” datestamp line appears within a
PARSING IN CURSORsection.
- 7629: Application now shows “All files are hidden” instead of “Drag trace files here or load sample files” when files are loaded but hidden.
- 7626: Fixed a bug causing mrprof to emit unnecessary text to
- 7624: Fixed a bug that could cause mrskew and mrprof to report incorrect shared SQL ID values.
- 7621: New and functions make it easy to transport files from one Method R Workbench user to another.
- 7607: New mrwhen command shows what time a trace file line or a specified tim value maps to for a given input file.
- 7599: mrprof now reports the total call count in the Profile by Statement sections.
- 7594: Workbench now remembers your selected sort order when you restart it.
- 7592: Added a new “Duration by database block address (DBA) for /db.*read/ calls” action.
- 7589: Added several new mrcrop commands to the predefined actions pane.
- 7588: Enhanced “Reload selected files” tool tip to note that you can shift-click to perform a force-reload.
- 7587: Fixed a bug that could cause the Workbench application not to automatically re-profile an input file that had been profiled by an older mrprof version.
- 7561: Fixed a bug causing mrprof to sometimes not open the HTML file it creates when using XML input.
- 7559: mrprof now recognizes
-?as a synonym for
- 7551: mrprof now preserves the existing formatting for multi-line SQL and PL/SQL text.
- 7544: Execution plan tables now include the row source start count.
- 7528: mrprof now exposes the
str(number of starts) statistics for row source operations.
- 7525: Fixed a bug causing advisory text to render “·” when it should render “0.0%”.
- 7523: mrprof new recognizes the
- 7517: Removed mrcallrm from the distribution, because the new mrcrop utility accomplishes the goals of mrcallrm and more.
- 7485: New pause/play button gives user control over whether mrprof runs during file load operations.
- 7471: Eliminated the requirement to set the environment variable called
- 7459: Method R Workbench can now be pinned to the Microsoft Windows taskbar.
- 7402: Refined the mrprof clock drift detection algorithm.
- 7302: Pressing the “Copy output” button when the output pane is empty no longer clobbers the clipboard.
- 6257: New mrcrop tool crops user experience data out of an undesirably too-large trace file, or splits user experience data into separate standalone trace files.
- 3993: Corrected highlighting of literal values in long SQL text.
- Posted by methodradmin
- On 2020-06-30
- 0 Comment