Categories
Release Notes: Workbench

Workbench 9.4.2.1

  • 8770: Fixed a File › Load bug that can occur when selecting both a file and its containing folder.
  • 8769: Fixed a bug that can occur when clicking the checkbox in the files pane header.
  • 8759: Fixed a File › Load dialog bug that could cause .trc files to be grayed out.

Categories
Release Notes: Workbench

Workbench 9.4.1.0

  • 8766: Fixed a bug causing the output pane content to not survive a Workbench upgrade.
  • 8765: Moved the Clear Application menu item from the View menu to the Edit menu. Moved the Clear Output item into the group of Clear… items in the Edit menu.
  • 8762: Relaxed the spacing around the edges of the output pane.
  • 8761: Relaxed the height of the command text widget.
  • 8760: Shift-click upon the checkbox in the files pane header row now inverts the selection.
  • 8758: New Edit › Clear Command History menu option.
  • 8753: New mrskew –top=all and –top=none options.
  • 8750: Extended the application’s undo/redo feature to cover edits in the command text widget, the action filter, and the file filter.
  • 8749: Moved “Save Output” menu item from the “File” menu to the “Edit” menu, so that now the option is proximal to the Cut, Copy, and Clear functions. Also re-ordered the buttons on the application.
  • 8747: Changed mrprof HTML report title from “Profile” to “Method R Receipt for Response Time™”.
  • 8744: Changed the default Z value to 0.01 seconds for island-related actions.
  • 8743: Moved Select menu options into the Edit menu, which is consistent with other application menus.
  • 8742: Fixed a bug causing Workbench to print a partial “Load files” report into the output pane when the File › Load… dialog has been opened and canceled.
  • 8741: mrskew disk.rc, p10.rc, and ssd.rc files are now cleaner and more maintainably written.
  • 8740: Improved the option order for the LIO and PIO count actions.
  • 8739: Fixed a bug preventing mrskew –group-label and –select-label expressions from accessing functions defined in the –init block, and that prevented the proper processing of UTF-8 strings in the –group-label and –select-label options.
  • 8737: Removed the mrls utility from the distribution. The Workbench application now performs all mrls functions more accurately and more efficiently than mrls did.
  • 8736: Removed the “Summary by file” action, because our “Copy selected file names to output (shift-click for FQPN)” button performs the same function more accurately and more efficiently.
  • 8735: Removed the “Details by file, for importing into Excel” action. The “Copy selected file rows to output (shift-click for CSV)” button performs the same function more accurately and more efficiently.
  • 8733: Fixed a bug with the checkbox column header’s tool tip in the files pane.
  • 8732: Fixed a bug with the tool tip on empty (normal) Status column values.
  • 8727: Fixed a bug causing Shift-Click to work improperly sometimes in the files pane.
  • 8725: Workbench now uses the system’s proper alert sound, played upon the proper alert sound output device, at the proper alert volume.
  • 8723: The File › Load operation now opens a more functional file open dialog on macOS.
  • 8721: Workbench now sounds an audible warning when you press Up at the top of your command history, or Dn at the bottom.
  • 8718: When focus is in the Workbench command text widget, you can use Up/Dn to scroll through your command history. Opt-Up/Dn will now move your cursor to the start/end of your command. Cmd-Up/Dn will move your cursor to the top/bottom of your command history list.
  • 8717: Clear Application now clears Undo and Redo.
  • 8710: Clear Application now clears the command text history.
  • 8708: Workbench now lets you open an HTML profile report by clicking on a value in the Version column.
  • 8707: HTML profile report exposes new Oracle tracing level attribute.
  • 8706: Fixed a problem where the Workbench SQLite database could have duplicate FILE rows.
  • 8704: Throughput numbers printed at the conclusion of a file load operation are now rounded, not truncated.
  • 8701: Modified an error message to suggest using mr1011 instead of Profiler 6.0.0.35.
  • 8698: Workbench now processes WAIT lines created by Oracle Database 23c.
  • 8697: Workbench now replaces Action parameters even if an Action’s command text is modified.
  • 8696: Workbench now restores command execution history upon startup.
  • 8695: Workbench application now automatically cleans its file cache upon startup.
  • 8694: Workbench has a new File › Move to Trash feature that allows you to clean up your filesystem through the Workbench application interface, on systems using JDK 9+.
  • 8693: Exit codes ($? values) and stderr vs stdout decisions are now more consistent with good *nix programming standards.
  • 8692: Fixed a problem that occurs when a file is loaded, moved to another folder, and then reloaded.
  • 8691: Workbench now exposes the trace-level of each input file in the files pane.
  • 8689: Fixed a bug where loading duplicate files resulted in mrprof errors.
  • 8688: Command output window now scrolls in sync with command text widget scrolling.
  • 8684: Fixed a problem with spacing in the output pane when using the “Copy selected file rows to output” button.
  • 8683: New “Copy selected file names to output” button makes it easy to list the names of all the currently selected files.
  • 8682: The Workbench application no longer lists file names at the tail of the command text in the output pane. The list of files is already available using either a tool’s –verbose option or the new “Copy selected file names to output” button.
  • 8681: Deleted the “Details by file, for importing into Excel” action, because our “Copy selected file rows to output” button performs the same function more accurately and more efficiently.
  • 8678: Exposed debugging interface to all of the mrcrop man pages.
  • 8677: mrcrop command line option semantic errors are easier to identify
  • 8672: Workbench now prints MB processed figure to the output pane when an action completes.

Categories
Release Notes: Workbench

Workbench 9.3.1.2

  • 8671: Workbench now respects the “report_output_font_name” GUI property in ~/.method-r/workbench/version/gui.properties.
  • 8668: ERROR lines now populate the $tim, $tim1, and $tim0 mrskew variables.
  • 8637: Fixed a bug causing the command text area not to resize properly when zooming.

Categories
Release Notes: Workbench

Workbench 9.3.0.17

  • 8661: Fixed a bug where Workbench on macOS would not load a .trc file that is dragged onto the application icon.
  • 8656: Fixed some “Show example output” previews to match what a given action’s output will really look like.
  • 8654: Replaced “Duration by database block address (DBA) for /db.*read/ calls” and “Duration by database file ID for /db.*read/ calls” action labels with more general “Duration by p1 for a given call name pattern” and “Duration by p1:p2 for a given call name pattern”. This will make it easier for people to extend these actions to other calls.
  • 8652: Enhanced launcher logging and new content at https://method-r.com/workbench/install makes installation and troubleshooting easier.
  • 8648: Fixed a bug causing the Check for Updates… download progress dialog to truncate the bottom third of the “Cancel” button.
  • 8645: Updated “Mastering Oracle Trace Data” book to reflect new spec for –group-label.
  • 8641: Made the “Duration by SQL ID, SQL text, and call name” report a little easier to read when the input trace is missing a PARSING IN CURSOR section.
  • 8640: Fixed a bug causing the “Duration by SQL ID, SQL text, and call name” action to malfunction.
  • 8639: mrskew now exits with an error code if any input file cannot be opened
  • 8634: mrskew now allows an expression value (not just a string value) for –group-label and –select-label.
  • 8633: Workbench now ships with our new “Tracing Oracle” book included; access it by clicking the button with the red-stripe book icon.
  • 8628: Workbench now runs natively on Apple silicon, about 3× times faster than on x86_64.
  • 8624: Confirmed that Method R Workbench application runs fine on Rosetta.

Categories
Release Notes: Workbench

Workbench 9.2.5.8

  • 8620: mrskew now recognizes BINDS sections that contain empty lines.
  • 8616: Workbench now saves the state of the “Pause profiling”/”Resume profiling” button after closing and reopening the application.
  • 8611: Fixed an inconsequential typo in mrcrop-bytes man page.
  • 8608: Refined the way Workbench uses sounds to notify the user that potentially long-running actions have completed.
  • 8604: Workbench utilities mrprof and mrskew now recognize new Oracle 23c trace elements CLIENT IP and CONNECTION ID.
  • 8592: Added –rc=file option to mrprof and mrcrop and fixed a bug that would cause the Workbench to fail if too many files are selected.
  • 8590: Fixed a bug on Windows when a user tries to use a trc→ Workbench file association.
  • 8587: Fixed a problem causing the profile report to render in the wrong font.
  • 8571: Fixed a View › Clear Application bug.
  • 8559: Fixed a problem that would occur when loading files before a prior load operation had completed.
  • 8553: Fixed a big causing the automatic transmission to re-profile traces sometimes when it shouldn’t need to.
  • 8551: Fixed a bug that could cause the files pane to get into a weird state when loading many files.
  • 8546: Added a throughput report in “%d MB/sec” format to the end of each response time report in the output pane.
  • 8542: Fixed a bug which could occur if you pause profiling and then unload all files.
  • 8536: “About” dialog now contains more links to provide information about the product.
  • 8535: Added a `mrwhen f.trc | nl -ba` example to the mrwhen man page.
  • 8532: Fixed a bug that makes mrwhen output incorrect for SQL statement text that exceeds 4KB in length.
  • 8520: New updates and corrections for the MOTD book.
  • 8481: Workbench now emits a “Load Files” summary into the output pane at the end of a “Load Files” operation.
  • 7619: `mrcrop –continued-trace` option now takes a wildcard character.

Categories
Release Notes: Workbench

Workbench 9.2.4.0

  • 8493: Fixed a Windows launcher bug that would prevent Workbench from automatically using any Java version newer than 1.8.
  • 8486: Fixed a bug where mrwhen might abnormally terminate while reading a 19c trace file.

Categories
Release Notes: Workbench

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
Release Notes: Workbench

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
Release Notes: Workbench

Workbench 9.2.1.2

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

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.