Method R Trace

Trace files, automatically. No searching. No clicking. No bother.

Method R Trace is a zero-click trace file collector for Oracle SQL Developer.

Every time you execute SQL or PL/SQL from your SQL Developer worksheet, Method R Trace automatically copies your trace file to your workstation, where you can load it into Method R Workbench, or open it with any application you choose.

Wow… Just wow. Absolutely blown away by how simple yet effective it is.

John Scott

Founder of APEX Evangelists

Method R Trace 18.2 (1:52)

Installing and Uninstalling Method R Trace

Installing

Method R Trace is commercially licensed software. You must purchase a license key at method-r.com to operate Method R Trace.

To install Method R Trace:

  1. Open Oracle SQL Developer.
  2. Click Help › Check for Updates….
  3. Select Search Update Centers.
  4. Click Add…
  5. Use the following values, and follow SQL Developer’s remaining instructions.
    Name: Method R Trace
    Location: https://method-r.com/distro/mrtrace-sqldev.xml
  6. Enter your license key at the bottom of the Help › About › Method R Trace panel.

Setting Up Oracle

Method R Trace requires some privileges and components to trace your code and fetch your files for you. When Method R Trace needs privileges for a database connection, it will pop up a dialog box showing you what it needs. If you are your own DBA, then all you need to do is enter a password, and you’re on your way. If your DBA is someone else, we’ve tried to make it easy for you both by providing a complete, documented script to do the job. You can see this script any time you want, in Preferences › Method R Trace › Installation Script.

Uninstalling

To stop Oracle SQL Developer from loading the Method R Trace extension, use Tools › Features… › Installed Updates.

To delete the Method R Trace extension from your computer, delete the following files, where $HOME represents your home directory, and $SQLDEV represents the Oracle SQL Developer installation directory:

  1. $HOME/.method-r/mrtrace
  2. $SQLDEV/sqldeveloper/sqldeveloper/extensions/com.methodr.trace.sqldevext
  3. $SQLDEV/sqldeveloper/sqldeveloper/extensions/com.methodr.trace.sqldevext.jar

To uninstall the Method R Trace Oracle Database components, use the SQL statements provided at the tail of the installation script listed at Preferences › Method R Trace › Installation Script.

Using Method R Trace

Method R Trace in Action

Once you’ve installed Method R Trace, select View › Trace File Downloads to see the Method R Trace main Trace File Downloads panel. Your screen should look something like the one here.

Now you’re ready to roll:

  1. Glance to make sure that Method R Trace is enabled. You will have to do this only once. If the indicator tells you that Method R Trace is disabled, then just click the indicator to enable it. If at any time you prefer not to trace the next execution, then, of course, click the indicator to disable it.
  2. Click this pathname if you want your trace file to be downloaded to a different directory than the one named here.
  3. Press the Run Script button to execute and trace the code on your worksheet. Note that the Run Statement button (the green triangle without the disk drive) does not trigger the trace file creation. …Well, sometimes actually it does, but the reasons are subtle, so it’s easier to remember the general rule: run and trace by using Run Script, not Run Statement.
  4. Your trace file will appear automatically as the top row in the Trace File Downloads panel.

This is why we call Method R Trace a zero-click trace file collector: once Method R Trace is enabled, and your destination directory is what you want, the only button you click—Run Script—is a button you’d have clicked anyway. The net effect: one precisely scoped trace file, zero extra effort.

To open a trace file directly from the Trace File Downloads panel, just click the file name. To open a directory, click the directory name.

You can move this panel or even hide it; just use View › Trace File Downloads to reveal it if you can’t see it.

Integration with Method R Workbench

Method R Trace is a trace file collector. Once you’ve collected a file, you’re probably going to want to feed that file to another software tool to analyze it. Method R Trace is designed to work best with the Method R Workbench application.

By controlling what directory Method R Trace will put your next trace file in, right from the Trace File Downloads panel, you can make it easy to feed files to the Workbench. Create directories to keep your trace files organized by project, application, and function, and instruct Method R Trace to put your files right where they belong. Then just load those files from your file manager (Finder, Explorer, …) into the Workbench files pane.