Low Cost Oracle SQL Optimization: Get a Free WireCache SQL Analysis
The WireCache SQL Analyzer is multi-step tool that provides a deep analysis of the interactions between applications and Oracle databases. The tool has three main functions:
- It provides an in-depth analysis of SQL traffic
- It provides an automatic estimate of the amount of database workload that could be handled by a WireCache appliance
- It creates a WireCache cache plan.
SQL Analysis begins with a passive, unintrusive capture of Ethernet traffic between an application and its database. This capture can be performed using standard tools on a typical computer, or it may be run by a WireCache Appliance. Typically, the Ethernet traffic is presented to the capture utility via a mirrored port, so that it has zero impact on operations.
In a second step, this Ethernet dump is parsed into SQL interactions. Every SQL statement executed is isolated and the tool shows performance characteristics for each statement: how often it ran, how many rows it returned, how much time it took to run, a histogram of response times over the capture period, and even more. This report provides a powerful window into application performance. For example, an analysis of a popular CRM application showed that almost 70% of the database server workload came from the twenty most frequently issued SQL statements.
To read more about this report, see the SQL Analysis Data Sheet.
By cross-referencing this report with the Oracle metadata that describes the structure and size of the database tables and columns, the tool is able to generate a cache plan. It can then estimate how much of the database traffic can be offloaded to the WireCache appliance, and an estimate of expected performance gains.
Learn How WireCache Can Upgrade Your Oracle Performance. Get a Free SQL Analysis.
