Analyzing the results

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