method-r.com

ILO, the instrumentation library for Oracle, is an open source project directed by Method R Corporation developers. It contains PL/SQL procedures for measuring tasks using Oracle extended SQL trace. The procedures are installed and compiled in the target Oracle instance and can be called by any language with access to the Oracle database tier.

Instrumentation Library for Oracle (ILO)

Diagnosing and repairing performance problems in an Oracle environment can be a complicated and time-consuming job. However, you, the Application Developer, can make the job much simpler by inserting a few extra lines of code, called instrumentation, into your applications. With the right instrumentation library, the job is easy. The Instrumentation Library for Oracle (ILO) gives you the lines of code you need.

The Payoff

Instrumentation makes your code faster, easier to maintain, and cheaper to write. Instrumentation makes your code faster because it shows you all of your opportunities for making your code more efficient, right while you're writing it. Instrumentation makes your code easier to maintain because it shows you exactly what your analysts are talking about when they say that your code is too slow. Instrumentation makes your code cheaper to write because it focuses your tuning efforts only upon the parts of your code where performance really matters. Good instrumentation is your immunization against premature optimization.

How It Works

You mark the beginning and end of your tasks with a single line of code, giving each task a module and action. Think of the action as the name of the task itself, and the module as the part of the application that the task represents.

Marking the beginning of any task is as simple as making a procedure call and including the values for MODULE, ACTION, and COMMENT.

When marking the end of a task, you again make a simple procedure call. Be sure to include all possible exit points of the marked task including any EXCEPTION sections in your code.

Licensing

ILO is open source software released under the GNU Lesser General Public License (LGPL), so you have full visibility and control of the code and what it does.

Pricing

ILO is free. You can find ILO at SourceForge.