Optimize SQL – Automates SQL statement optimization by analyzing the original SQL statement and using artificial intelligence to exhaustively rewrite the syntax and apply the Oracle optimization hints. This produces a list of semantically equivalent and syntactically correct SQL statements, so you can test run them to find the best ones for your environment. Optimize SQL can also provide indexing alternatives so you can decide whether to use rewrites only, index changes only, or both.
Optimize Indexes – Evaluates an application SQL workload and identifies indexing changes that will improve the application’s overall performance. Application workload can be collected from a number of sources, including Oracle Automatic Workload Repository, Quest Foglight Performance Analysis, or source code.
Batch Optimize SQL – Identifies problematic SQL in your application, either through the Oracle SGA, Foglight Performance Analysis, or source code and automatically optimizes it to find and present rewrites that execute faster.
Scan SQL - Identifies problematic SQL statements in your database environment by automatically extracting them from your source code. Scans SQL retrieves and analyzes the execution plans for the extracted statements and classifies them according to complexity. You can then optimize statements classified as problematic using Optimize SQL or Batch Optimize SQL.
Inspect SGA – Enables capture, view, and analyze of executed and running SQL statements from Oracle's System Global Area (SGA). Once Inspect SGA collects information from the SGA, you can use Scan SQL to analyze and classify SQL statements captured. You can then send SQL statements that Scan SQL classifies as problematic or complex to Optimize SQL or Batch Optimize SQL for optimization.
Analyze Impact – Identifies the SQL execution plan changes that may have occurred within a set of SQL statements to evaluate the impact that database changes may have on the SQL. SQL can be collected from a number of sources including Oracle Automatic Workload Repository, Quest Foglight Performance Analysis, or source code.
Manage Plans – Enables you to manage either Oracle Stored Outlines or SQL Plan Baselines. Stored Baselines are optimization hints which help maintain an execution plan for a SQL statement. SQL Plan Management enables you to tune execution plans without changing the source code.