Method R Trace is a zero-click trace file collector for Oracle SQL Developer 4.0. Every time you execute SQL or PL/SQL from your SQL Developer worksheet, Method R Trace automatically copies a carefully scoped extended SQL trace file to your SQL Developer workstation, where you can tag it for easy lookup later. The main panel lets you manipulate all the trace files you have collected. You can click to open a trace file with any application you choose, like the Method R Profiler or your favorite text editor.
I just finally got ’round to installing Method R Trace in SQLDev, and I can say, “Wow... Just wow.” Absolutely blown away by how simple yet effective it is.
Apex Evangelists Ltd
Halifax, United Kingdom
New Features and Bug Fixes
Buying Method R Trace
Method R Software Information Library
Check out our library for more information about Method R software:
- Why you need a profiler for Oracle (video 4:06)
- The Method R Profiling Ecosystem (blog post)
- The Method R Profiling Ecosystem (video 1:04:51)
- A First Look at Using Method R Workbench Software (PDF)
- Getting Started with Method R Tools (video 1:13)
- Cary Millsap’s story of Method R Trace (blog post)
- Method R Trace for Oracle SQL Developer version 4 (video 1:44)
Installing Method R Trace
You install Method R Trace from within Oracle SQL Developer’sdialog. From there, you have two choices:
Method 1 (the one we recommend)
- Select .
- Set Name to “Method R Trace” and Location to http://method-r.com/update/mrtrace.
- Download the Method R Trace zip file to your local system from http://method-r.com/update/mrtrace/com.methodr.trace.sqldevext.zip.
- Select .
- Click to select the file you downloaded.
Setting Up Oracle
Method R Trace requires a few 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.
Method R Trace is commercially licensed software with a free 14-day evaluation period. You must purchase a license to operate the software past its evaluation window. You may purchase a license at any time by clicking thebutton found at or .
Using Method R Trace
Once you’ve installed Method R Trace, selectto see the Method R Trace main panel. Your screen should look something like this:
Now you’re ready to roll:
- Glance to make sure that Method R Trace is enabled. You will only have to do this once. If the indicator tells you that Method R Trace is disabled, then just click on the indicator to enable it.
- Press the button to execute and trace the code on your worksheet. Note that the 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 , not .
- If you want to open a trace file, just click its name in the panel.
Frompanel you can open files, edit tags, delete files, or filter results. (Here’s where everyone always asks: if you delete a file from the panel, no, it does not remove the original trace file from the database server.) You can move this panel or even hide it; just use to reveal it if you can’t see it.
...Now you know why we call Method R Trace a zero-click trace file collector: the only click you need to collect a trace file is the click you did in step 2, which is a click you would have had to do anyway. The net effect is any trace file you want, with no extra effort.
Tagging and Filtering
Each time Method R Trace collects a trace file for you, it will ask you to tag that trace file. You can select default values for your tags at, on the tab. If you don’t want it to ask every time, you can change this behavior on the tab.
You can change a tag’s value any time you want. Tags are physically stored in the local copy of the trace file. Once you’ve tagged a trace file, you can use thewidget to display only files whose details contain the filter text you’ve entered. In this way, you can focus your attention on only a subset of the files that you have collected.
Defining Oracle SQL Developer external tools lets you create your own trace file Open commands. To create a new external tool, select. This will open a dialog where you can select an application. Once you have added this application, it will appear in the context menu when you right-click on a trace file name.
For example, if you are a licensed Method R Profiler user, you can add the Method R Profiler to your list of external tools by using the following settings:
|Caption for Menu Items:||Method R &Profiler|
|ToolTip Text:||Method R Profiler|
|Icon Location:||/your-path/etc/graphics/MR Profiler.icon.iconset/icon_16x16.png|
Uninstalling Method R Trace
To stop Oracle SQL Developer from loading the Method R Trace extension, use thepanel, on the tab.
To delete the Method R Trace extension completely from your computer:
- Browse to the Oracle SQL Developer installation directory.
- Change directory to sqldeveloper/sqldeveloper/extensions.
- Delete the file com.methodr.trace.sqldevext.jar.
- Delete the folder com.methodr.trace.sqldevext.
You can uninstall the Method R Trace Oracle Database components using the SQL statements provided at the tail of the installation script at.
For product support, visit our Support page at http://method-r.com/support.