Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 3, 2002

Statement Tracer for Oracle

By DatabaseJournal.com Staff

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 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 Beta Release

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM