|
|
Slow or high-overhead statements can lead to serious problems during development, testing, and finally, to the end user by causing frustration and unnecessarily increasing the amount of time it takes to perform basic tasks. Performance tuning new and existing code has previously been an art form that few have mastered. Isidian® SQL Insight provides an abundance of information, statistics, charts, and guidelines to help a developer of any expertise level achieve quality, high performance tuning capabilities.
Using SQL Insight's performance tuning features, a user may identify poor performing statements in current development, evaluate in-use code to locate and correct system bottlenecks, and produce detailed graphs and information on statement tuning progress.
The Auto-Tune functionality within Isidian® SQL Insight will automatically parse and reconstruct poor-performing SQL statements to produce faster, more reliable variations that can replace your current code. This feature also analyzes the optimizer's interpretation of the statement and diagnoses what steps can be performed to increase its efficiency.
The Auto-Tune combines the base SQL Editor, dual Explain Plan interfaces, and the Comparisons graphing interface to provide a simple, automated solution to your performance tuning needs. |
 |
 |
The base Explain Plan interface is an extremely powerful tool that provides, not only the well-known tree view, but also the stepped order of operations, all know information pertaining to the operation (partition information, bytes, cost, etc.), a detailed definition of the operation selected to help understand the underlying process and complexity of each step, and a describe interface that automatically displays details on the object utilized within the selected operation.
Isidian® SQL Insight also provides additional statement analysis tools such as SQL Trace and AutoTrace. |
Statement Comparisons provide diverse use when performance tuning statements or an application. This functionality can be used to graph statistics displaying and reporting the tuning progress on a single statement or set of statements, identify one or more poor performing statements from a large set of statements, and provide detailed database statistics on one or more statements.
The customizable interface will automatically identify problem statements, show tuning progress, and allow the printing or saving of the comparison information for reporting purposes. |
 |
 |
Browse the shared pool with the SGA Browser, used to easily identify those statements needing improvement by seeing the execution statistics of all statements being processed by the database and comparisons of the statistics of each statement against the average statement processed.
The SGA Browser also integrates our powerful grid capabilities to allow multiple column sorting, filtering, and grouping of statements to help identify those statements in most dire need of attention. |
PL/SQL may be also be tuned, using the tools within Isidian® SQL Insight Professional Edition, via the PL/SQL Profiler, which provides in depth charts and details on the timing and repetitions of each line of code executed during the process. The PL/SQL Profiler also provides a historical view, showing modifications made to the statement and the impact per line and overall.
Available within the Professional Edition. |
 |
 |
Various tools and coding aids are provided within Isidian® SQL Insight to help generate quality code that meets your performance needs without further tuning. Shown here is the Check Query Joins functionality, designed to eliminate the worry of cartesian products by modifying your query to include all possible joins that may not have been included. |
The tools described above are only part of vast feature set Isidian® SQL Insight provides. For further information, please review the Product Data Sheet, or download the trial edition today.
|