Monday, 16 August 2010

MR Trace: SQL Developer Add-In Gets Trace Files for You

Cary Millsap and the folks at Method R have devised a cute add-in to Oracle SQL Developer.  It's called Method R Trace (MR Trace or "Mister Trace" for short) and it does a very simple thing elegantly: when you run PL/SQL code, it automatically turns tracing on and off at the right times, fetches the trace file for you, and presents it in a list right there on the screen.

I read about it on Cary's blog.  Here's a short video demo with Cary at the keyboard:  

He's proud of it because it's the "smallest software tool we've ever designed," but it's usefulness seems way out of proportion to its size.  Just not having to bug the DBA to get your trace files seems worth it to me!

(I'm going to start a new policy here that I hope will catch on among all bloggers: anytime I talk about a product, I'm going to disclose whether or not I received anything of value for the mention.  I didn't, though I did win a Method R door prize at an Oracle User Group meeting once.)


  1. All things considered, it is a simple and quick procedure to complete the MyTHDHR Employee Self Service Login record and help to claim Home Depot Employee Benefits to complete the My THDHR Login Process.Home Depot Ess Login – MyTHDHR Login


  2. This is great advice! Very honest and practical.I really enjoyed this post.Nice post! Visionworks