Blog Posts Release Announcements

Method R Workbench 9.4

Yesterday, we released Method R Workbench This article is a tour of some of the 50 new application behavior changes.

Command History Scrolling

In Workbench 9.3, it was a pain to try to find a given report in the output pane. For example, do this:

  1. Run the “Time by line range” action upon a 1,000-line trace file, with 1- as the range. The output will be 1,000 lines.
  2. Run the “Duration by call name” action upon the same file. The output will be about 15 lines.
  3. Run the “Time by line range” action again. Another 1,000 lines.
  4. Now, find the “Duration by call name” report, which now is buried between two 1,000-line reports.

This was a fun design problem. My initial idea was a “table of contents” dialog. It would list the actions that had been run, and then clicking on one would scroll the output pane back to the first line of that action’s output. But I hate dialogs.

It sucks when you hate your own best idea. But that’s what teams are for. Jeff proposed a far better idea: simply link the command history feature with the output pane. So now, finding that “Duration by call name” report is as easy as:

  1. Arrow up and down through the command text field until you get to the action you want to the report for. Then, presto!, there’s its report in the output pane.

We want our software to feel like “PFM” (pure magic). This design element is one of the opportunities you seek to fit that description. It wasn’t easy to implement, given that the size of the output pane is variable (View › Zoom), but that’s our problem to worry about, not yours.

CSV for Importing into Excel

One of the stories I like to tell was when we helped a big company fix an overnight batch job duration problem by exporting our files panel content into CSV that you can copy and paste into Excel. As a result of that engagement, we added a new runnable action called “Details by file, for importing into Excel”. It used our mrls utility. The problem is, mrls is slower and less accurate than mrprofk, which creates the information for the files pane.

There’s no need to be slow and wrong when you can be fast and right. So we eliminated the action in the actions pane, and we added a shift-click feature to the existing “Copy selected file rows to output” button. Now it’s the “Copy selected file rows to output (shift-click for CSV)” button. It’s both accurate and blazing fast.


Clearly, most of the information transfer from the Workbench application to your brain occurs through your visual channel. But one day in July 2020, one of our customers said this:

Running mrskew is so fast and the resulting display update so fluid I often cannot even tell if it ran…

After studying the problem a little bit, we decided to begin to use sound as an additional channel for transmitting information from our Workbench application to your brain. Now, when you run a command that might take a while, you’ll get a little thumbs-up or thumbs-down sound when it’s finished. Now you can look away from the screen and still know definitively that your action has finished. We added that feature in August 2020, in Workbench 9.1.

One thing had been bugging me, though: the sounds didn’t really fit in with the other sounds my system makes. On macOS and Windows, there’s actually a system settings option that allows you to specify an alert sound for your system. You get to choose which sound you want, how loud it should play, and which device it should play on. Prior to 9.4, our Workbench application didn’t respect those settings. In 9.4, we do.

It’s nice to fit in.

Undo and Redo

We worked long and hard on undo and redo in this release. Prior to 9.4, undo was restricted to the files pane. You could undo box-checking, and you could undo load and unload operations. We found the feature confusing to use, though, for a variety of reasons. At the same time, we didn’t offer any undo features in the command text field (the text field at the top of the output pane).

So, in 9.4.1, we’ve added good old-fashioned undo and redo with ⌘Z and ⇧⌘Z (Ctrl-Z and Shift-Ctrl-Z on Windows) in the command text field and both the filter fields.

Move to Trash

Sometimes in our Workbench workflow, we come across files that we know we’re never going to want to load again. Those are the files with zero durations, or files with trace level 0 (see our new “Level” column, which reveals each file’s Oracle tracing level). Going to the filesystem browser to delete those files is tedious and dangerous—I hate look-here, but click-there workflows. It’s just easier to select the files you don’t want and delete them, with File › Move to Trash (it’s Move to Recycle Bin on Windows), right in the Workbench application.

It may sound dangerous, but don’t worry, Move to Trash just moves items to your trash can. If you make a mistake, you can still retrieve them.

If you don’t see the Move to Trash (or …Recycle Bin) option in your File menu, then you should update your JDK version to 9+. You can see the version you’re using by clicking Help › Diagnostics.

Label Expressions

In my August 2023 article called “A Design Decision,” I talked about an enhancement that lets you use expressions in --group-label and --select-label values. What we didn’t realize at the time was that, in those expressions, mrskew wouldn’t let you refer to functions you’d defined yourself in the mrskew --init block. In 9.4.1, we’ve fixed that problem.

It’s a neat feature. We use it now in our three histogram RC files (disk.rc, p10.rc, ssd.rc) to make our code more elegant. The ability to use --group-label='label(0)' is the trick. I expect our users to push the feature even harder. See, for example, Jared Still’s amazing --init blocks on Slack.

And More…

In the past few years, we’ve been increasingly required to carve through hundreds or thousands of trace files. We’re talking so many files that referring to “*” on the command line overfills the command line buffer. So each release in 2023 and 2024 has had some features to make managing lots of trace files easier. You can see all about what we’ve done at our Workbench Release Notes page.

I hope you enjoy!

Release Announcements

Workbench 9.2

Method R Workbench 9.2 adds bug fixes and exciting new features to 9.1. The application now runs on any version of Java at or greater than Java SE 8. We have replaced the muddy zebra-striping in the files pane and the HTML5 output with a cleaner, more elegant, Tufte-inspired three-row banding method. Table headers in the HTML5 output are now sticky, which means they always remain conveniently in view, regardless of how many rows a table has (it’s especially convenient for analyzing long execution plans). And the Workbench application takes less time to start up in this release, especially when you’ve been working with lots of trace files.

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.

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.

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
Release Announcements

Trace 19.2

Method R Trace 19.2 is ready for Oracle SQL Developer 19.2. It adds undo to the Clear button, eliminates the confusion over license key entry, and fixes a pesky bug that prevented you from seeing Oracle session attributes in your trace files.

Release Announcements

Workbench 8.1

Method R Workbench 8.1.0 optimizes working with thousands of files at once. Now you can load folder objects from your Finder/Explorer application. Loading files is fast and now clutter-free in the output pane. One of our tests loads (which includes profiling) over 5,000 trace files (about 5GB) in just over five minutes. A new “Copy selected file rows to output” button pushes selected data from the files pane to the output pane, where you can access it easily with copy and paste. The new Help › Open Diagnostics menu option makes it easier to get support for the application.

Release Announcements

Trace 18.2

Today we celebrate the release of Method R Trace version 18.2. Method R Trace is our zero-click trace file collector for Oracle SQL Developer. Version 18.2 is the follow-up to version 3.1, which has served us well since 2015.

Release Announcements

Workbench 8.0

Method R Workbench 8.0 brings you an all-new application that integrates the Method R Profiler and Method R Tools utilities into a unified tool for supporting your trace file analysis workflow. Loading a file in the Workbench application now automatically profiles it and makes dozens of pre-packaged reports available to you with just a click. It’s the world’s first application designed to make it easy to manipulate hundreds of trace files in one place.

Release Announcements Videos

Profiler 6.0

Method R Profiler is a software tool for measuring Oracle user response times. Version 6 is our biggest upgrade in ten years. You’re going to love what we’ve done.