In that regard, I'm trying out some tools. Today it is MR Trace, or Mister Trace as the folks at Method-R like to call it.
They have a nice little SQL Developer plugin so I don't have to think a whole lot, which is good. I need to save those cycles for more important things.
What is MR Trace?
...is our company’s 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, I would encourage you to watch this short video featuring Mr. Millsap.
Installation is a snap. I'll run through it real quick here.
First, check for updates.
Check the Third Party SQL Developer Extensions
Scroll down or do a search for trace.
Dead simple appears to be their mantra, and we don't get far from that.
I didn't set up anything before hand, so here is what happens when you first run a SQL (or PL/SQL) statement:
You are prompted to choose how you want to do this. Since this is my sandbox, I just went for public to make things easier. Doing so requires SYS access of course.
After that you get a splash page from Method-R.
So here's what I ran:
That first row highlighted in the bottom pane, that's my trace file.
I open it up using the SQL Developer Viewer which looks like this:
A closer look...
Now, I don't have much of a clue about what all these means. That's the next step.
I like that this really is "dead simple," especially when it comes to us developers. Simple is good and usually appreciated.
Martin suggested checking out Trace Analyzer or TRCANLZR, which can be found here (MOS account required). Looks pretty neat, but again, I should kinda learn what the heck these things are telling me before I get too far along.
If you have a suggestion for a tool to check out, leave it in the comments. Hopefully I'll be able to get to it soon.
I would prefer something that just gives me red, yellow and green lights...:)