Method R Workbench Video Tips

A collection of short video tips to help make the most of your Method R Workbench experience.

  1. Method R Software Workflow (1:54)
  2. Automatically Opening Profiles (1:43)
  3. The “Automatic Transmission” (1:36)
  4. The “Show mrprof details” Button (1:32)
  5. Which File to Open Next? (1:03)
  6. The Pig Nose (1:25)
  7. Connection Pools (2:21)
  8. Locale Code (0:54)
Trace Release Notes


  • 8360: Simplified the Oracle Database object installation process.
  • 8343: Database object installation script no longer complains when the METHODR user already exists.
  • 8342: Added a new “Statistics level” preference to the Preferences panel, and orthogonalized the “Bind values” preference to have the same type of widget as the other preferences.
  • 8336: Changed the name of the extension in the View menu from “Trace File Downloads” to “Method R Trace”.
  • 8329: We’ve created a whole-new even more efficient ultra-clean design for Method R Trace. The files pane, which had always been a redundant subset of your Finder/Explorer, is gone, replaced by a status pane that informs you about your most recent activity.
  • 8328: Updated help text to refer to the central authoritative documentation source at
  • 8326: Replaced the big “Method R Trace Enabled” and “Method R Trace Disabled” toggle button with a tidy green/clear lamp indicator on the toolbar.
  • 8320: Simplified the Preferences › Method R Trace › Setup panel by eliminating the redundant “Enable SQL tracing and file downloading” option.
Release Announcements

Trace 21.2

Method R Trace 21.2 is ready for Oracle SQL Developer 21.2. We’ve created a whole-new, even more efficient design for Method R Trace, where all the commonly-used controls are now on the toolbar. We’ve added a new STATISTICS_LEVEL control on the Preferences page, and we’ve simplified the process of creating the Oracle Database objects required by the product.


Oracle tuning assignments can be pretty easy

Blog Posts Videos

Some things you probably didn’t know about Oracle tracing (Chicago edition)

Today, I had the honor of speaking online to the Chicago Oracle Users Group in their “20 in 2020” webinar series. In this presentation, I talk about why it’s OK to trace everything on your system and how to do it safely, and I explain why you’d want to do that in the first place.

Some things you probably didn’t know about Oracle tracing

Method R for capacity planning

The practical approach Cary explained for capacity planning brought to light a whole other application for the tool.

Nancy Spafford · DBA and Tech Lead · Lawrence Livermore National Laboratory · Livermore, California
Release Announcements

Workbench 9.1

Method R Workbench 9.1 adds bug fixes and exciting new features to 9.0. New audio feedback makes it easier to know when reports finish, reorganized menus add features and make things easier to find, new copy and paste capability makes it easier to pull data from the files pane into reports and emails, and new Select › Inverse feature makes it easier to manage lots of files.

Workbench Release Notes


  • 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
  • 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.
Workbench Release Notes


  • 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.
Workbench Release Notes


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