Method R Workbench

Oracle response time measurement with microsecond precision.

Method R Workbench is our complete set of Oracle Database response time measurement tools for database application developers, DBAs, and decision-makers.

In 1974, Donald Knuth wrote that “the universal experience of programmers who have been using measurement tools has been that their intuitive guesses [about which code is critical] fail.” It’s still true today, but in the Oracle ecosystem, it can be hard to find measurement tools you can trust.

Method R Workbench is what we use, and it’s what hundreds of developers and DBAs have used to stop guessing. We have tools, manualsbooks, courses, …everything it takes to get you to, “I got this.”

These are the best Oracle performance diagnostic tools I’ve ever used.

Andrew Zitelli

Principal Software Engineer with Honors
Raytheon

Method R Workbench 9: A Whole New Way to See Oracle® Performance (5:37)

Click to see a Method R profile report

Method R Workbench 9(July 1, 2020) Trace files are the richest performance data that an Oracle Database application can give you. The detail is a double-edged sword, though. You crave the detail, but without great tools, it’s miserable trying to manage it all. The new Method R Workbench 9 stands ready to help you filter through gigabytes of trace data, to find what you need quickly and easily. Let us open your eyes to a world that you may have never imagined, a world in which you can see where all your application’s time is going.

…And under one minute I was looking directly at the problem. No more guesswork. No more Sherlock with the magnifier goofing around. And the time spend in search of the problem can easily be used to find a better solution.

Eduard Turea

Consultant
Frostbyte Consulting

Method R Workbench 9.0 can filter effortlessly through gigabytes of trace data. It is…

  • Faster. Does it seem like every time we release, we make something faster? Well, we do. And it never gets old. This time, mrls and mrskew are about 20× faster. It makes a huge difference. Oh. And now file loads are parallelized, which makes you 4× faster on a quad-core laptop.
  • Easier. The new mrcrop utility helps you find your user’s experience, even if it’s buried among tens of thousands of trace files. The new mrwhen utility shows you exactly when something happened. This makes the data directly relatable to your users.
  • More Helpful. We’ve improved our advisory text, so now the report gives you even more guidance, even in those tricky cases where the trace file just makes no sense.
  • More Informative. We’ve added CPU, LIO, PIO, row count, and network roundtrip information to the files pane of the app, and we’ve added EXEC call counts to more sections in the profile report. Because it makes your analysis go faster.

Technical Details

What is Method R Workbench?

Method R Workbench is a software bundle consisting of the Method R Workbench application, and the Method R Trace extension for Oracle SQL Developer.

The Method R Workbench application is used for processing Oracle Database event 10046 extended SQL trace files. It runs on macOS, Linux, and Microsoft Windows, where it can process trace files generated by an Oracle Database version 11.1 and newer, running on any operating system.

The Method R Workbench target user base is developers, database administrators, decision-makers, and anyone wanting precise measurements of end-user response time experiences with an Oracle-based system.

The main design goals for Method R Workbench are:

  • To help you explain exactly why an Oracle-based program consumes the duration that it does.
  • To help you predict the precise impact upon such a program duration, expected to result from a proposed change to your system .
  • To help you organize and manage all the Oracle trace files you’ll accumulate throughout your application’s life cycle.

Users may access Method R Workbench through a Section 508-compliant (29 U.S.C. 794d) application, or through a scriptable command line API. Users generally transfer trace files from the Oracle Database systems being analyzed to their local machine with the Method R Trace extension for Oracle SQL Developer (included), or with software tools such as FTP or NFS.

The centerpiece of Method R Workbench is a response time profiler called mrprof that creates a richly detailed HTML5 report. The fundamental element that is repeated throughout this report is the profile, which has this basic structure:

SubroutineTime (sec)Call countAvg. latency
Total100%51.855
disk read90%46.6682,6390.018
other10%5.18731,0380.000

This format makes simple work of knowing exactly why your application consumes the response time it does. The HTML5 document uses color and structure to guide your analysis. With minimal training, a Method R Workbench user can—in just minutes—identify the root cause of an Oracle-based application performance problem, propose sensible solutions to it, and predict the end-user response time impact of each proposed solution.

In addition to the profiler, Method R Workbench contains a trace file data mining tool called mrskew that helps you answer hundreds of ad hoc performance questions. Among the more than 25 prepackaged mrskew actions are reports like:

  • Show the durations experienced by your application users among a directory full of trace files from a connection pool.
  • For a loop of SQL executions, show the iteration that takes the most time, along with the input values (“bind variable values”) that drove it.
  • Show I/O subsystem latencies grouped by Oracle data file ID.

Method R Workbench also contains other utilities that help with cropping trace files, converting Oracle timestamp data to wall clock times and back, and creating scriptable chains of mrskew reports.

Method R Workbench includes the Method R Trace extension for Oracle SQL Developer. When Method R Trace is enabled, it will create and retrieve an Oracle event 10046 extended SQL trace file that precisely accounts for the execution duration of SQL and PL/SQL within a SQL Developer worksheet. Oracle SQL Developer can be configured to run Method R trace file processors directly from its Open With feature. You can also drag trace files from Oracle SQL Developer and drop them into Method R Workbench.

Who uses Method R Workbench?

Lots of companies, including Fortune 100 companies, use Method R software.

  • Oracle application developers use Method R software to find and fix bugs in their code, and to measure and optimize their code while they’re writing or repairing it.
  • Oracle DBAs use Method R software to prevent performance problems by measuring application performance on test systems, and to monitor and troubleshoot user performance experiences on production systems.
  • Non-technical users and managers use Method R software to connect detailed Oracle performance data with the end users’ performance experiences that affect the business.

Trials and Licenses

Trials

Anyone can download Method R software from our downloads page. However, Method R software will not run without a valid license key. You can request a self-service trial license key from our downloads page. A trial license key allows you to try all of a product’s features for 14 days, before buying a license:

  • In trial mode, Method R Workbench will run only upon pre-designated demonstration trace files that we distribute.
  • In trial mode, Method R Trace is not restricted in any way.

Read about how Method R software works in our comprehensive product documentation. Try Method R software on your own.

Licenses

Method R software requires a valid license key to run in full-feature mode. In full-feature mode, you can run Method R software upon any trace file you want. You may purchase a license key from Method R or one of our authorized resellers. A Method R license key is valid for a pre-defined duration. You can see the remaining duration of your license key in each application’s About dialog. Once a license key expires, Method R software returns to trial mode. Click here to see the complete Method R Software License Agreement.