- Written by Cary Millsap
- Created: 21 February 2012
By now, a few thousand of you are aware of MR Trace, the Method R Trace extension for Oracle SQL Developer. It’s the easiest way to create a perfectly time-scoped trace file and put it onto your desktop computer without having to do any of the work of talking to your DBA, finding your trace file directory on the database server, groping (or grepping) through all the files to find the one you want, and then copying the file across your network to where you want it.
MR Trace eliminates all that work for you, completely automatically, with no extra clicking. You just run your SQL or PL/SQL code in your SQL Developer worksheet with the Run Script (F5) button click, and—presto!—your trace file appears on your desktop.
But what if you want to fetch a trace file that you didn’t just now create from SQL Developer? What if you want to grab that trace file created by the GL Posting job that ran last night? What then? Enter MR Trace version 2.
Let’s review. With MR Trace version 1, you got a Local Trace Files panel, which I like to dock at the bottom of my Oracle SQL Developer window. It shows all the trace files that have been retrieved for me (copied from the database server) and which are now stored locally on my desktop. The files that have been retrieved most recently are emboldened, in case the sort order you’ve selected causes them not to be listed at the top. Whenever you use the Run Script (F5) button with MR Trace enabled, trace files automatically arrive here for you to do what you want with them. ...I use the tools in the Method R Workbench package.
With MR Trace version 2, you get a new “MR Trace → Trace Files” item in the navigation panel for each of your Oracle Connections. Clicking the “Trace Files” item opens a new window that lets you access all the trace files on the database server you’re connected to. To copy a trace file to your Local Trace Files panel, just double-click the file you want in the Trace Files panel for your connection (or right-click like I've done in the screen shot).
Do you have 42,000,000 trace files on your system? Don’t worry, MR Trace isn’t going to show up in one of my “Messed-Up App of the Day” blog posts for fetching all 42,000,000 rows across your network on every screen refresh. We’ve used the standard SQL Developer filter widget to give you control over how many files show up in your Trace Files list. By default, MR Trace will fetch information about only the 100 newest files in the directory.
In spite of packing a whole lot more power, MR Trace version 2 is just as easy to install as Mr Trace version 1. We use a few server-side Java and PL/SQL objects to enable the new magic, which install automatically the first time you use the new feature. If you have SYSDBA privileges, you can complete the installation yourself in just a few seconds. If you don’t, then MR Trace gives you the complete installation script that you can send to your DBA to enable your connection. That way your DBA can see exactly what you’re asking for in a single, easy-to-read sqlplus script.
MR Trace version 2 still costs just us$49.95. If you already own MR Trace version 1 and would like to upgrade, just contact us, and we’ll be happy to give you a coupon good for a us$20 upgrade discount. Buy MR Trace version 2 today at our online store, or visit the Method R Trace web page for a free 14-day trial.