Home » Other » Marketplace » A nice tool to view sql trace data
A nice tool to view sql trace data [message #144243] Tue, 25 October 2005 13:05
Messages: 5
Registered: October 2005
Junior Member
There is a tool to help you identify the most time-consuming SQLs in a procedure with a lot of SQL statements. You still need to do sql trace and use TKPROF to format data. Then you can use the tool named SQLTraceViewer:

SQLTraceViewer is developed to help Oracle DBAs or Developers with their task of performance tuning. It is a Java-based tool to view Oracle SQL trace data formatted by TKPROF. The Viewer can filter and sort data, so it can help to find the most time-consuming SQL statements with great ease.

Consider the following scenario: A business application built with Oracle has many complicated processes. One of the processes is taking a long time to run and the Oracle developer decides that the cause may be in one or many of the SQL statements in that process. The developer enables SQL trace and obtains trace data, then formats the data with TKPROF. After that, the developer screens through the trace data statement by statement to find the problematic SQL. Due to large number of statements in the formatted SQL trace file, this screening process is taking a long time, and sometimes the developers fails to find the most time-consuming SQL on the first attempt. With the help of SQLTraceViewer, the screening process is much more efficient and accurate. The developer opens the file with SQLTraceViewer and, after filtering and sorting data, the developer finds the time-consuming SQL right away!

It's freely downloadable from:

Please share your experience here, so we can improve the tool to serve us better.
Previous Topic: APB for a DBA!
Next Topic: Oracle / Linux Position in MD
Goto Forum:

Current Time: Thu Jul 09 10:22:10 CDT 2020