Hotsos Home Page

Hotsos Profiler

The first time I used it, Hotsos Profiler helped me reduce the run time of one query from 6½ hours to less than 11 seconds.

—Guðmundur Jósepsson, Index Software Solutions & Consulting

Why You Need Hotsos Profiler

Conventional performance management tools look at your performance from your computer's perspective. But to maximize the impact of performance improvements to your business, you need to view performance from the user's perspective.

One of the most difficult tasks facing system performance analysts is to answer the seemingly simple question, “What's taking so long?” Hotsos Profiler brings you the answer within two mouse clicks, for any Oracle-related performance problem.

Learn what’s taking so long, in just two mouse clicks.

No other tool makes you as efficient.

When You Need Hotsos Profiler

Hotsos Profiler is indispensable in situations including:

Solving performance problems

The diagnostic power of the Hotsos Profiler is extraordinary. On countless situations in which root causes have evaded detection for weeks or even months, new Profiler users have resolved problems permanently in less than an hour.

Server consolidation

Nearly every system we examine uses more than twice as much hardware capacity as it needs. Imagine the cost savings of eliminating the waste that would enable you to run your applications on half the hardware. The Hotsos Profiler reveals waste like microscope reveals bacteria.

Preventive maintenance

By comparing Hotsos Profiler output of critical business processes over time, it becomes easy to recognize gradual performance deteriorations before your users do.

How It Works

Hotsos Profiler automates the most complicated task in the efficient performance diagnostic method described in Optimizing Oracle Performance: converting the extremely detailed chronological record of a user action's response time consumption into a format that is easy for you to use.

Two clicks from problem to root cause

How We're Different

Distinctions of the Hotsos Profiler include:

Methodical two-step solution path to any problem

Traditional methods and tools require you to have dozens of tools and scripts to diagnose all the kinds of problems that Oracle systems can have. With the Hotsos Profiler, the two-step sequence of diagnosis steps is always the same, no matter what the problem. Hotsos Profiler is the first tool for Oracle that doesn't require you to guess what your problem might be before it can help you fix it.

Complete, accurate resource profile

Hotsos Profiler shows you where all your user's response time went, even when your time was consumed in application tiers other than the database. Most other tools encourage you to ignore the so-called idle events, which serves only to conceal the root cause of entire categories of important performance problems.

Proper aggregation of shareable SQL

Applications that don't use bind variables are particularly troublesome to diagnose with traditional tools like tkprof or trcanalyzer, where one bind variable mistake can show up in your output as twenty thousand distinct problems with individual contributions of 0.005% of your response time. Hotsos Profiler will show the issue as a single problem with 99% impact. No other tool does this.

Complete accounting of recursive SQL relationships

Sometimes recursive SQL is the cause of a performance problem. When it is, you need to know the relationship that the recursive statements have to your application code. Oracle's SQL trace files contain all the information you need to see that relationship, but only the Hotsos Profiler is able to extract the information from the trace file.

Additional information display conveniences

Hotsos Profiler provides several distinctive information display conveniences that speed the problem diagnosis process, including:

  • SQL statement text formatted for easier reading

  • Histograms for wait events (I/O, latch, enqueue, etc.) to reveal information about skew in operation durations

  • Statistics presentation optimized for prioritization of LIO operations

  • Statement-level statistics shown both inclusive and exclusive of recursive SQL (tkprof shows only one; which one varies by release)

  • Identification of which PIO blocks are managed through the Oracle buffer cache and which are not

  • Statement-level statistics shown in per-execute and per-returned-row form for convenient analysis

  • Numbers formatted with thousands separators for easier reading

Pricing and More Information

Prices vary by configuration and volume. For more information, please write sales@hotsos.com or call +1.888.8HOTSOS.