Statement Tracer for Oracle

April 3, 2002

Above Software has made available a free beta release of their new Statement Tracer for Oracle software. Statement Tracer can be downloaded and used for free through the end of April (an official release is expected in early May). Here's a link to the download site for the 1.0.1.5 Beta Release: http://www.aboves.com/downloads.

Here's a short synopsis of Statement Tracer for Oracle from the Above Software Web site:

Statement Tracer for Oracle is an effective and easy-to-use solution for debugging programs interfacing with the Oracle RDBMS. Statement Tracer presents a requests history log for any application that requires SQL*Net or Net8 to access Oracle server. The layout of this log is very convenient and easy to read. With this solution you don't have to ask your database administrator for help or browse huge trace files every time when you want to know what a particular application does.

Just run the Statement Tracer and you will get all the information you need. Statement Tracer:

• Is a very time-effective tool for application development and debugging
• Allows technical support engineers and database administrators to find problems without help from developers
• Gives evaluation of your application performance in real time in order to identify possible problem areas

Statement Tracer for Oracle allows you to visualize:

• Requests to a server for compilation and execution, including:
  • SQL queries texts
  • DDL statements
  • Anonymous PL/SQL blocks and stored procedures execution requests
• Input (in) and output (out) parameters for all the request types
• Notifications on commit and rollback of transactions

With Statement Tracer you can:

• Monitor several applications simultaneously
• Save the monitoring results into log as a text file for further processing
• Customize a layout of the log by choosing different events

Statement Tracer Tools:

Statement Colorize Tool--Highlights requests containing a text pattern specified by you and moves between them

Statement Assembler Tool--Assembles request syntax and parameters together. It returns ready-to-use SQL statements

Download Statement Tracer for Oracle 1.0.1.5 Beta Release