What is Method R Workbench?
Method R Workbench is a suite of software tools 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 running on any operating system.
Users may access Method R software 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 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 that creates a richly detailed HTML5 report whose fundamental element is the profile, with this basic structure:
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.
Method R Workbench contains a collection of software utilities for querying and editing trace files. These tools, for example, help you answer performance questions that are outside the scope of the profiler.
Method R Workbench includes the Method R Trace extension for Oracle SQL Developer version 4. 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