Method R Trace
is a third-party extension for the Oracle SQL Developer product. 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”) generates a trace file that corresponds carefully to the response time of your execution, and then it automatically copies that 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. With just one click, you can open a trace file with any application you choose, including the Method R Profiler
, a MR Tools
utility, or even your favorite text editor.