Home
Resources
Downloads
Related Links
Contact Us

Free Demo

Trace Profile Reporter

TPR
What is TPR?

TPR is a tool used to gather and analyze Oracle extended SQL trace data.

From this single application you can gather and analyze sql trace data which is then turned into an in-depth report, allowing you to pinpoint performance problems. No more remembering complex commands, and searching for trace files. Simply point and click to select the session you wish to analyze.

The resulting report provides extensive information in a sorted, well organized format. Immediately revealing exactly where the database is spending all of it's time.

Features

 - Connect to remote databases to trace sessions.
 - Automatically copy trace file to local machine for analysis.
 - Creates an easy to read, linked HTML report.
 - Summary statistics for all waits.
 - Display top N statements in trace.
 - Breakdown of statistics on a per statement basis.
 - Per/exe and Per/row execution stats.
 - Display any parse or statement errors.
 - Display statement specific latch, lock, read and write statistics.
 - Display bind variable values (for level 12 trace).
 - Aggregation of statement statistics for identical statements.
 - Linked descriptions for wait types.
 - Supports all database versions that support the wait tracing interface (7.3 onwards).

Product Comparison Chart

Product:

TPR

tkprof

TRCANLZR

ubtools profiler 

hotsos profiler 

Installation

None (single exe)

None (single exe)

Requires install of several scripts/packages in each database where trace files will be analyzed

Requires web server and compatible java servlet engine

Requires internet access for each profile run.  Unless installed locally (see cost)

can start/stop tracing for remote database sessions

yes

no

no

no

no

creates an easy to read, linked html report

yes

no (text only)

no (text only)

yes

yes

Statement list sorted by total execution time

yes

no

no

yes

yes

display wait stats

yes

only in 9i and later

yes

yes

yes

display execution plan

yes

yes

yes

yes

yes

display bind variable values

yes

no

yes

yes

yes

breakdown read/write/latch/lock stats per statement

yes

no

?

yes

yes

Cost

$39

Free (included with oracle installation)

Free (obtained from oracle metalink)

$285

*  $$$$$ See Below


To the best of our knowledge, the information contained herein is correct. If you note any mistakes or inconsistencies, please Contact Us.

* - Prices no longer listed on site. Previously had been $750 for 10 runs. Was quoted several thousand for a local install.

Licensing

  Licenses are available on a single user basis.
  This means licensing TPR for use by a single user on a single machine.
  For site or corporate licenses, contact .
  Current licenses include free upgrades to all 1.x revisions.
  A demo evaluation version is available in our downloads section.


 Home | Info | Download | Links | Contact