Installing Method R Trace

SQL Developer Extension

Method R Trace is an Oracle SQL Developer extension. To install Method R Trace:

  1. Obtain a license key from our trial license key request form or our online store.
  2. Open Oracle SQL Developer.
  3. Click Help › Check for Updates…
  4. Select Search Update Centers.
  5. Click Add…
  6. Use the following values:
    • Name: Method R Trace
    • Location: https://method-r.com/distro/mrtrace-sqldev.xml
  7. Follow SQL Developer’s remaining instructions.
  8. Enter your license key in the Preferences › Method R Trace › License panel.

If you prefer to use the SQL Developer Install From Local File(s) feature, you can download the distribution file yourself from our downloads page.

Setting Up Oracle

Method R Trace requires some privileges and components to trace your scripts 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 made it easy to send a copy of the script to your DBA for review and execution. You can see this script in Preferences › Method R Trace › Installation Script.


Using Method R Trace

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 it 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: a 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 it’s hidden.


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:

  • $HOME/.method-r/mrtrace
  • $SQLDEV/sqldeveloper/sqldeveloper/extensions/com.methodr.trace.sqldevext
  • $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.