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

Announcing Method R Workbench 8!

Nothing is better than Method R Profiler for explaining why a program took the time it did. But how can you manage the hundreds of Oracle trace files you might gather in just one session of tracing? Method R Workbench is the application that helps you organize, manage, and query all of the trace files you’ll collect during your whole application software life cycle. How fast did this thing use to run? Why does it take longer now? With one integrated application, the answer is at your fingertips all day long.

Method R Workbench 8.0 is a whole new way to work with trace files. It is…

  • Faster. It’s even faster than Method R Profiler 7.1. Which is truly remarkable.
  • More Organized. Workbench is the first application in the world that helps you organize, manage, search, and really use hundreds of trace files at once.
  • More Helpful. It’s almost as if the application knows what you’re going to need before you need it.
  • Easier. The command line API is still there, but you’re probably not going to need it once you see everything the new application can do for you.

Meet Profiler 7.1, the newest tool in the Workbench.

(January 23, 2018) Method R Profiler 7.1 contains the feature that people have been wanting since the very beginning: every report contains new advisory text that guides you through your analysis. After interpreting hundreds of trace files over two decades, we’ve programmed Profiler 7.1 to write our report right into the shareable HTML5 document itself. Now, every time you run the Profiler, it tells you what we ourselves would say about your data.

The new advisory sections are really useful. It’s like having Cary and Jeff in my browser!

Dallas Deeds

Database Administrator
Fortune 100 Company in Columbus, Ohio

Method R Profiler 7.1 provides over 50 enhancements to our best profiler ever. It is…

  • Faster. Method R Profiler 7.1 is faster on every platform, especially Microsoft Windows.
  • More Accurate. There’s no more confusing “unreported” time. New debugging options give you complete information about unaccounted-for time.
  • More Informative. New fields and new sections, like the experience-level Profile by Database Call and the statement-level Profile by Execution Plan give you deeper insight with fewer clicks.
  • Easier. Our new Check for Updates feature makes upgrading a snap. License key management is now just a single copy and paste. The new Show all details option (--noelide) makes it easy to see all your data.

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. The tools run on macOS, Linux, and Microsoft Windows, where they 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:

Subroutine Time (sec) Call count Avg. latency
Total 100% 51.855
disk read 90% 46.668 2,639 0.018
other 10% 5.187 31,038 0.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.

Who uses Method R Workbench?

Lots of companies, including many 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.