You can export the contents of a file to a .csv file and open it
in XSL. There is also a support tool called the SQLProxy Analyzer
which analyzes and summarizes JDBC trace records. This tool is available
as part of MTCP in Eclipse.
CAUTION:
Contact Sterling Selling and Fulfillment
Foundation Customer
Support when using this tool.
About the sQLProxy analyzer
The SQLProxy
Analyzer is a tool used to analyze the data in the SQLProxy logs.
The Analyzer has the following capabilities:
- Can process multiple log files in a directory or a single log
file
- For each log file (which represents a database connection), the
Analyzer produces a summary of the unit of work (UOW). (There might
be multiple UOWs in a connection.)
- Can calculate the number of executions and total cost of the SQL
- Response Time Buckets, which are useful if you have a many SQL
instances and a high average SQL time. The response time bucket will
show you which bucket the SQL response time falls into.
- Provides execution plans, which are automatically generated by
the Analyzer. You can specify any Oracle database (it does not necessarily
have to be the one from which the SQL was captured). This enables
you to point the analyzer to a very large database that has up-to-date
Oracle statistics.
- For each unit of work, the Analyzer provides:
- A summary of all the SQL (SQLs are grouped together to get a small
summary from a very large file)
- The LOCK HOLDING time (therefore, you can see if the system grabs
locks that could impact other workloads)
- Oracle EXPLAIN plans, which assist you in assessing whether certain
queries will potentially get slower as the database grows larger