| Method R Trace |
MR Trace is a Method R extension for the Oracle SQL Developer interactive development environment. It is a zero-click Oracle trace file collector. Every time you execute SQL or PL/SQL from your SQL Developer worksheet, MR Trace (we call it “Mister 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’ve collected. You can click to open a trace file with any application you choose, like the Method R Profiler or your favorite text editor. Now, version 2 allows you to retrieve any trace file on your system, in an easy-to-use, natural interface to your trace file directory. Interested? See Cary Millsap’s story of MR Trace, or watch our 3-minute video demonstration. I just finally got ’round to installing MR Trace in SQLDev, and I can say, “Wow... Just wow.” Absolutely blown away by how simple yet effective it is. John Scott Apex Evangelists Ltd PricingMR Trace is $50 usd per user. You can try before you buy with our 14-day free trial. Method R Software Information LibraryCheck out our library for more information about Method R software:
Installing MR TraceIf you have web access from your SQL Developer workstation, you can add the MR Trace Update Center URL in or in . The URL is: http://method-r.com/update/mrtrace/ If you don’t have web access from SQL Developer, you can install directly from our zip file, using . Server Side Components and PrivilegesMR Trace requires a few privileges to do the dirty work of tracing and fetching files for you. When MR 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 . RegisteringThe MR Trace extension is initially downloaded as trial software. A license must be purchased in order for the extension to operate after the trial expiration date. You can purchase a license at any time by clicking the “Buy License” button found here or here . UninstallingYou can prevent extensions from loading into SQL Developer from the menu. However to delete the file extension from your computer you'll need to follow these steps:
Server side components will need to be uninstalled manually. SQL statements are provided at the bottom of the installation script. The installation script can be found here: . Getting Your Trace FilesMR Trace makes it easy to get your trace files, whether you’ve generated them from a SQL Developer worksheet, or even if you want to fetch files created by someone else. Run Script ButtonMR Trace works when you use the button in Oracle SQL Developer. Note that the button doesn’t trigger the trace file creation. ...Well, sometimes actually it does, but the reasons are somewhat subtle, so it’s easier to remember the general rule: You trace by using , not .
Files that have been downloaded are visible in the “Local Trace Files” panel. From there you can filter the results, open files with external applications, jump to the folder structure or edit the tags. You can move this panel or even hide it; just use to enable it if you can’t see it. Enable and DisableIf you ever want to run scripts without tracing them, just click the button in the lower right-hand corner of the Method R Trace panel. To enable automatic tracing again, click the button. Navigation NodeIn the Connections navigation panel there is a Trace Files node for each connection. Expand the MR Trace node, then click the Trace Files node. This node will display a panel containing a filtered list of files of the UDUMP directory. From this panel you can select and download files. If the server side components have not been installed, then you’ll be presented with a panel to launch the installer.
You can download selected trace files by highlighting the files you want, then clicking the Get button in the upper left corner of the Trace Files panel. You can also select the files then right-click and select Get from the context menu. After the download completes, the file will be visible in the Local Trace Files panel. Managing Your Trace FilesNow that you have your trace files on your workstation, you need to organize them. The MR Trace tagging and filtering features make it easy. TaggingBy default, MR Trace will ask you to tag your trace file. You can edit these tags later if you want to. They’re stored in the trace file to make it easy for you to find your files when you need them. You can control the tags dialog and many other options in . External ToolsYou can configure MR Trace to open your trace files in an external tool. To create a new external tool, right-click on a trace file, and select from the MR Trace context menu. This will open a file dialog where you can select an application to open the trace file. Once you have added this application, it will appear in the context menu. FilteringThere are two ways to filter the list of files displayed in the Trace Files panel. Entering text in the text field will quickly reduce the list of rows to ones that match the input. You can also filter the rows before they are brought to your workstation. This will improve the response time as well as assist you in searching for files. You can control these settings by clicking the icon, or in .
Product SupportFor product support, please visit our Support page. Product Change LogClick here to view our MR Trace bug fixes and new features. |
