Case Study
Toad® for Oracle Xpert reduces SQL query time for Ithaca College from 10 minutes to 0.09 seconds.
Read now »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
SQL Optimizer
for Oracle
Visit shop.quest.com to buy this product online.
Buy Online »
Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »

SQL Optimizer for Oracle

Maximum Performance Through SQL Performance Tuning and SQL Validation

Quest SQL Optimizer for Oracle proactively identifies potential performance issues and automates SQL optimization by scanning and analyzing running SQL statements, PL/SQL, or other source code. It explores every possible way of improving SQL performance tuning. If you already have the best-performing SQL, it proves it. And if you don’t, it provides you with the best-performing SQL alternativePlus, it offers index optimization and plan-change analysis.

Features

Optimize SQLAutomates 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.

Sys Reqs

System Requirements

Before installing Quest SQL Optimizer for Oracle, ensure your system meets the following minimum hardware and software requirements:

Platform

1 GHz Processor

Memory

512 MB of RAM minimum, 768 MB of RAM recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

90 MB of disk space for installation

Note: The disk space required may vary based on options selected for installation.

Operating System

Microsoft Windows Server 2003 32-bit and 64-bit

Microsoft Windows XP Professional 32-bit and 64-bit

Microsoft Windows Vista 32-bit and 64-bit

Microsoft Windows Server 2008 32-bit and 64-bit

Microsoft Windows 7 32-bit and 64-bit

Microsoft Windows 8 32-bit and 64-bit

Microsoft Windows Server 2012

.NET Framework

Microsoft .NET Framework 4.0

BrowserMicrosoft Internet Explorer 6.0 or later
PDF ViewerAdobe Acrobat Reader 7.0 or later (for viewing the Installation Guide)
Database Client

Oracle SQL*Net

Oracle v8 Client (Net8)

Oracle v9 Client (Net9)

Oracle v10 Client (Net10)

Oracle v11 Client (Net11)

Oracle 12c Client

Oracle Instant Client

Database Server

Oracle 8.1.7, 9i, 10g, 11g R1, 11g R2, 12c

SQL Optimizer has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

Cloud Database ServiceOracle databases running on Amazon EC2

Virtualization Support

Before installing SQL Optimizer, review the following for virtualization support:

Application Virtualization

SQL Optimizer has been tested with the following:

  • Citrix XenApp 5.0 on Windows Server 2003 (Service Pack 2) using the Citrix Presentation Server 4.0
  • Citrix XenApp 6.5 on Windows Server 2008 R2
Desktop Virtualization (VDI)SQL Optimizer has been tested with Quest vWorkspace 7.0 running on Windows XP Professional 32-bit (Service Pack 2).
Server Virtualization

SQL Optimizer has been tested with the following:

  • VMWare ESX Server 2.0.2 running on Windows XP Professional 32-bit (Service Pack 2) with Oracle 9i and 10g R2
  • Oracle VM 2.2.0 running on Oracle Enterprise Linux 5 Update 2 64-bit with Oracle 10g R2
  • Oracle VM 2.2.0 running on Oracle Enterprise Linux 5 Update 3 32-bit with Oracle 11g R1
  • Oracle VM 3.1.1 running on Windows Server 2008 R2 with Oracle 11g R2
  • Oracle VM 3.2.2 running on Oracle Linux Release 6 Update 4 Media Pack v1 for x86 (32-bit) with Oracle 10g R2.
  • Oracle VM 3.2.2 running on Windows Server 2008 R2 64-bit with Oracle 11g R1.
  • Oracle VM 3.2.2 running on Oracle Linux Release 6 Update 4 for x86_64 (64-bit) with Oracle 11g R2.

Note: SQL Optimizer may work in virtualization environments other than the ones in which it was tested.

 

Learn More

Support for This Product