Products

Hotsos 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 Hotsos 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.

Pricing

Hotsos ILO is open source released under the LGPL license, so you have full visibility and control of the code and what it does.

Releases

You can find it at Sourceforge.

The Hotsos ILO Timer Extension Package is an API between Hotsos SLA Manager and ILO. You can find more information about the Timer at the Hotsos portal. You will need to login to see the Timer Extension Package information.