Categories
Workbench Release Notes

Workbench 9.2.3.0

  • 8478: Fixed a bug where loading a file might not work, which could lead to a “Cannot synchronize…” dialog.
  • 8463: Adjusted some advisory text.

Categories
Workbench Release Notes

Workbench 9.2.2.2

  • 8460: Fixed the mrls man page to emphasize that mrls ignores files with names not matching `*.trc`.
  • 8459: Changed the size of the About and Help › License dialog boxes to not require the vertical scrollbar upon opening.
  • 8457: Created some new event sub-types and modified some tolerances.
  • 8454: Added instructions at method-r.com/software/workbench/install about how to change Java versions.
  • 8452: Improved advisory text for cases when “%d other subroutines” accounts for PROFILE-RELEVANCE-THRESHOLD or more of total response time.
  • 8451: New `mrcrop bytes` command makes it easy to crop a trace file by a byte offset range.
  • 8449: Improved description of –include=VERSION field.
  • 8444: Clarified the `mrcrop linerange` –start-line and –end-line option documentation.
  • 8441: Refined the blue Method R Workbench icon.
  • 8435: New action: “Duration by SQL ID, SQL text, and call name”.
  • 8433: mrprof now honors sub-typing of synthetic calls in cdefs.xml, such as the new “unaccounted-for within dbcalls [trace error]” subtype.
  • 8432: Improved advisory text for a case in which a single “unaccounted-for within dbcalls” call duration dominates the call type’s overall contribution.

Categories
Workbench Release Notes

Workbench 9.2.1.2

  • 8405: mrskew now can read trace files with missing SQL statement text.
Categories
Workbench Release Notes

Workbench 9.2.0.23

  • 8404: Updated the installation instructions URL in the application’s “Startup Error” dialog.
  • 8401: Made column widths consistent in the mrskew man page all.rc example on p14.
  • 8400: Workbench will now run with any version of Java from 1.8 onward.
  • 8395: All Windows binaries are now signed.
  • 8384: Eliminated mrskew $t alias for $tim.
  • 8377: Added mean, min, and max information to profile by subroutine total lines.
  • 8374: Table headers are now sticky, which means they always remain conveniently in view, regardless of how many rows a table has.
  • 8373: Moved the skew column in profile by subroutine tables to the tail of each row, so that min and max data will be adjacent to each other.
  • 8370: Eliminated redundant $oraver mrskew variable, and fixed $oracle_release variable to recognize new Oracle Database 19c trace file version stamps.
  • 8361: Replaced zebra-striping of the files panel with a cleaner, more elegant, Tufte-inspired three-row banding method.
  • 8355: The Method R Workbench application now allows you to open a profile report by clicking on an ID or Size column value.
  • 8322: Changed Evaluate › Run menu option name to Evaluate › Run Action.
  • 8319: Profiler error messages generated by the app are now separated by a newline.
  • 8313: Eliminate unused aliases $h, $cur_id, $cid, and $ses_id.
  • 8307: Workbench now recognizes Oracle Database version info printed in the new 19c format.
  • 8304: New mrskew prepackaged action answers the question, “How much time would an execution have spent reading blocks if it did no block re-reads?”
  • 8301: If you specify mrskew –rc=file for a file that does not exist, mrskew will now terminate immediately upon parsing the command line and not run the report.
  • 8299: The “Duration by SQL ID”, “LIO count by SQL ID”, and “PIO count by SQL ID” reports now all use the –alldepths command line option.
  • 8297: mrskew now interprets ERROR lines as dbcalls.
  • 8296: Added new mrskew $oerr expression variable.
  • 8292: Fixed a bug that could cause an “can’t build document from input xml file” error.
  • 8291: Fixed a bug that caused Preferences panel tabs to render illegibly.
  • 8283: Removed the .zip item from mrprof man page Description section, and –first_member and –member options, because mrprof does not process .zip archives.
  • 8282: Updated mrwhen man page with information about new features.
  • 8281: Fixed a bug causing the Workbench application to change the cursor to a “Mickey hand” in some situations where clicking is not allowed.
  • 8280: Fixed a bug that would cause a reload of a relocated file to produce a “can’t open file” error.
  • 8276: Workbench startup and the View › Clear Application feature now take less time than before, especially for a database with many loaded files.
  • 8273: Added mrprof –load and –create options.
  • 8272: Added documentation for mrprof –workers option to the mrprof man page.
  • 8271: Added new $module_id and $action_id variables, and eliminated the now-ambiguous aliases $service, $serv, $module, $mod, $action, and $act.
  • 8261: Fixed a bug that caused the Workbench application on macOS not to load files dropped onto a Workbench icon.
  • 8250: mrskew now exposes a mrtime function and variables $time0 and $time1.
  • 8249: Fixed a bug causing mr1011 not to properly scale c values on RPC EXEC lines.
  • 8248: Cursor no longer changes to a hand when hovering over a File value when the file does not exist.
  • 8247: New “Copy selected file rows to output (shift-click for CSV)” button function creates CSV output.
  • 8245: Moved Workbench installation instructions from https://method-r.com/man/mrworkbench to https://method-r.com/software/workbench/install.
  • 8241: Clarified and simplified some mrwhen warning messages.
  • 8240: mrprof now warns when you try to process a file that mrprof is not designed to process.
  • 8239: Added all the content (prerequisites, installation, troubleshooting, …) from https://method-r.com/man/workbench to https://method-r.com/software/workbench.
  • 8237: Documented instructions for activating a Workbench license key at https://method-r.com/software/workbench/install.
  • 8235: Clicking on a trace file’s Directory value now opens the file manager, even if the file’s folder no longer exists.
  • 8228: Fixed a bug causing mr1011 not to scale c values correctly.
  • 8227: Updated mr1011 man page with information about new features.
  • 8226: mr1011 now appends a tim field to each WAIT line in pre-10g trace files.
  • 8225: Workbench application now makes a success sound when a file load is complete.
  • 8222: Method R Workbench 9 is certified to run on macOS 11.1 Big Sur.
  • 8221: Added the mr1011 manual page to the application Help menu.
  • 8220: Added mention of the mrcrop utility to the mrprof man page.
  • 8216: Offset the stateful “Show mrprof details” button from the other buttons in the main toolbar, matching the spacing of the stateful “Show example output” button in the action pane toolbar.
  • 8215: Re-labeled hover hint from “Elide mrprof details” to “Hide mrprof details”.
  • 8210: Modified Workbench icon to meet macOS 11 specifications.
  • 8208: Added new mr1011 –scale option.
  • 8207: Fixed a bug causing the “# mr1011…” comment line not to be written to the output.
  • 8206: Fixed a bug where CLIENT, ACTION, and MODULE values included characters introduced in 18c that aren’t part of the actual values.
  • 8203: Fixed a bug causing mrprofk not to properly recognize the end of a SQL statement in a PARSE ERROR section.
  • 8192: mrcrop now denies any attempt to overwrite a file.
  • 8191: Improved the performance of mrwhen –tim for large files.
  • 8190: Added new mrwhen –drift and –drift-only options.
  • 8184: Fixed a bug causing the Workbench application to miscalculate how much time is remaining on the license key.
  • 8183: Fixed a bug causing mr1011 not to emit the sqlid field on PARSING IN CURSOR lines.
Categories
Workbench Release Notes

Workbench 9.1.0.3

  • 8172: Fixed a problem causing some mrcrop error messages to be formatted inconsistently.
  • 8170: Fixed a bug that would cause the string “null” to be appended to the file name when using File › Save Output….
  • 8166: Fixed a bug that caused abnormal termination of mrprofk and other utilities when using a trial license key.
  • 8164: Moved all installation prerequisites and troubleshooting documentation to the mrworkbench man page, at https://method-r.com/man/mrworkbench.
  • 8163: Moved prerequisite documentation from a web page to the mrworkbench man page, and improved the installation troubleshooting advice on the mrworkbench man page.
  • 8162: Added to the mrprof man page that the default value of the –trace option is the empty string.
  • 8160: Improved the Method R Workbench for Windows dialog text when WinRun4J cannot find a suitable JVM.
  • 8159: Improved error message formatting.
  • 8157: Fixed a bug causing the “%.3f seconds” message at the end of an erroneous action execution to concatenate improperly with the error message.
  • 8154: Added a new “Cut output” feature (Edit › Cut Output and a new button) for the output pane.
  • 8152: The Workbench application now saves the state of the most recently selected item in the actions pane, so that when you start the application, the action that was selected at the end of the previous session is selected at the beginning of a new session. Using View › Clear Application will reset the selection to “Duration by call name”.
  • 8151: Reorganized the Workbench application menus to make features easier to find and execute.
  • 8148: Removed the Edit › Clear Output and Files menu option, which didn’t work properly. Replaced with a new View › Clear Application option, which clears the files pane, files filter, actions filter, and output pane with one click.
  • 8141: Eliminated the confusing Reload and Unload right-click options in the files pane.
  • 8139: New right-click option for any value in the files pane makes it easy to copy the value under the cursor for easy pasting into an emails, reports, etc.
  • 8136: Fixed a bug that would cause mrskew not to recognize the –listrc option when used in conjunction with the –noinitrc option.
  • 8121: Workbench application now uses audio feedback to notify the user of action completions, errors, and so on.
  • 8103: Added two new reports to the actions pane: “Duration by PARSE ID” and “Duration by call name for given PARSE ID value”.
  • 8091: New Select menu options give another means to access the Select › All and Select › None functions, and the new Select › Invert function allows you to quickly invert your visible files pane selections.
Categories
Workbench Release Notes

Workbench 9.0.2.5

  • 8142: Fixed a bug that could cause an empty argument value to be processed improperly in mrskew commands on Microsoft Windows.
  • 8134: Fixed a bug that could cause quotes to be processed improperly in mrskew commands on Microsoft Windows.
  • 8130: The application now prepends the start time of an action execution to the name of the action in the output pane. The time consumed by the action now prints after the final row of the action’s output.
  • 8126: The Workbench application now pops a dialog when you’re getting close to your license expiration date.
  • 8120: Fixed a bug that prevented Workbench from automatically restarting after an upgrade.
  • 8115: Renamed “Duration by call begin and end times” to “Duration by call begin TIM and end TIM”, and added --top=0.
  • 8113: Fixed a column alignment problem with “Duration by EXEC ID, SQL ID, and placeholder value set” report format.
  • 8105: Tool tip text for Directory and File values now shows the full name of the directory or file, which helps especially when a restricted column width prevents you from seeing the full name.
  • 8104: Fixed a bug that would mistakenly allow the Workbench application to load a .trc.gz file.
  • 8102: Standardized quoting in predefined action commands.
  • 8096: Fixed the mrskew man page description of the --pform and --csv options.
  • 8090: Fixed a bug where mrcrop linerange might not correctly copy the SQL statement text for a PARSE ERROR.
  • 8086: Fixed a bug for Workbench on macOS that would cause the 10 MB Java library folder to be duplicated instead of linked symbolically, when upgrading from version 9.0.1 or earlier.
Categories
Workbench Release Notes

Workbench 9.0.1.0

  • 8085: Improved handling of nested syscalls, which eliminates some false-negative TRCBUG2 warnings.
  • 8083: Fixed an exception that could occur when mousing over the white region to the right of the rightmost column header.
  • 8082: Fixed a bug that could cause a Workbench for Windows utility to throw a “Could not find or load main class…” error if the product installation pathname contains whitespace.
Categories
Release Announcements

Workbench 9.0

Oracle 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.

Workbench 9—a whole new way to see Oracle performance
Categories
Workbench Release Notes

Workbench 9.0.0.66

  • 8119: Fixed a Check for Updates… bug that prevented Windows users from upgrading Workbench 8.1.2.1 to Workbench 9.0.0.66. The workaround is to download Workbench 9 from the Method R downloads page.
  • 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 and –ignore-multiple-sessions-file options 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 –trace option to a file called *.trace.
  • 8046: Fixed a bug causing Workbench not to open the output HTML file when using the mrprof –trace option.
  • 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 Preferences › Profiler › Workbench Parameters › Use this many parallel profilers.
  • 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-formats option 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 –ofile %s specifier to %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 Preferences › Profiler › Workbench Parameters › “Auto-open HTML when loading one or two files” option replaces the old and less useful “Open up to this many HTML files per load” 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 PERL5LIB environment variable.
  • 7870: Renamed mrskew –glabel and –slabel options to –group-label and –select-label.
  • 7860: New mrskew $base_name and $dir_name variables 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 –eula option. Users can find the license agreement information in each utility’s manual page.
  • 7828: Standardized the processing of options used by every utility. Now, –help, –license, –man, and –version all 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 –timunit, –cpuunit, and –trcunit options and the $cpuunit and $timunit variables.
  • 7801: Documented the mrskew %calls ($calls{key}) variable.
  • 7800: mrskew is now more 10–20× faster than before.
  • 7799: Consolidated and simplified error reporting for .rc file 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 START-TIM and END-TIM columns to a more logical place in the output.
  • 7782: mrls –debug option now writes debugging information to stderr.
  • 7781: Renamed mrls TIM0 and TIM1 columns to START-TIM and END-TIM.
  • 7780: New mrls –tags-dbfile option allows you to specify which SQLite database to use for retrieval of TAGS information.
  • 7777: New mrls –include=:all and –exclude=:all options obviate the old –none and –details options.
  • 7775: Added new mrls STATUS column values.
  • 7774: Replaced the old mrls options like –cpu and –nocpu for including and excluding columns with new –include and –exclude options.
  • 7772: The mrls –sort option now takes a column heading (e.g., DURATION, SIZE, VERSION, etc.) as its argument.
  • 7763: mrls now dies if you use –sort on a field and then exclude that field from the output.
  • 7762: mrls is now more than 20× faster than before.
  • 7759: Deprecated the mrls –scanmax option; to request full-precision output, use –include=DEP or 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 START value for a file. Now it simply warns when there is no timestamp in the input trace file.
  • 7737: Removed under-utilized mrls options: –trcunit –timunit –cpuunit –precision –human –dformat –tformat –units
  • 7722: Now you can use mrls -r as an alias for mrls –reverse.
  • 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 –recursive (-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 –where criteria.
  • 7630: Fixed a bug that caused mrskew to calculate $ssqlid incorrectly when a “***” datestamp line appears within a PARSING IN CURSOR section.
  • 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 stderr when using –nohtml.
  • 7624: Fixed a bug that could cause mrskew and mrprof to report incorrect shared SQL ID values.
  • 7621: New File › Export… and Import… 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 –help.
  • 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 LOBARRTMPFRE database call.
  • 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 MRWORKBENCH_INSTALL.
  • 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.
Categories
Workbench Release Notes

Workbench 8.1.2.1

  • 7511: Deleted “Remove think time” action from the actions pane.
  • 7506: New “Details by file, for plotting in Excel” action makes it easy to create Gantt charts in Excel for trace file data.
  • 7503: Fixed a bug that could cause abnormal termination during mrprofk statement merging.
  • 7492: Fixed a bug causing hierarchy indentation symbols in execution plans to misalign.
  • 7477: Fixed a bug that could require a user to shift-click a duration when a simple click should have worked.
  • 7476: Fixed a bug that could cause the License/About dialog to show the license key text when it shouldn’t.
  • 7475: Updated The Method R Guide to Mastering Oracle Trace Data book references to match the release of the third edition.
  • 7474: Each utility’s man page now includes .rc file details.
  • 7473: Changed “Method R Tools” references in all the command line tools’ manual pages to “Method R Workbench”.
  • 7470: Documented the required setting of MRWORKBENCH_INSTALL in all of the command line tools’ man pages (except for mrprof, which does not require it).
  • 7469: Each utility’s man page now includes details about MRTOOLS_RCPATH (except for mrprof, which does not use it).