SQL Optimizer for Oracle

SQL performance tuning and SQL validation that maximizes performance

Proactively identify potential performance issues and automate SQL optimization by scanning and analyzing running SQL statements, PL/SQL, or other source code.

Experience SQL optimization with an automated approach. Detect and analyze problems directly from running SQL statements, PL/SQL or other source code.  Plus, this advanced tool actively explores ways to improve SQL performance through tuning, and offers the best-performing SQL alternative. It also provides complete index optimization and plan-change analysis.

Features

  • Optimize SQL – Analyzes and improves original SQL statements automatically by using artificial intelligence to rewrite the syntax, and apply the Oracle optimization hints. Generates semantically equivalent and syntactically correct SQL statements that you can test run to determine the best ones for your environment. Plus, provides indexing options that enable you to choose rewrites only, index changes only, or both.
  • Optimize indexes – Enhances an application’s performance by analyzing its SQL workload (from Oracle Automatic Workload Repository, Foglight Performance Analysis or source code), and identifying indexing changes that will improve it.
  • Batch optimize SQL – Automatically optimizes PL/SQL for performance by detecting issues (through Oracle System Global Area (SGA), Foglight Performance Analysis or source code) and providing rewrites that execute faster.
  • Scan SQL - Extracts inefficient SQL statements automatically from your source code, plus reviews execution plans from these statements and categorizes them by complexity. Optimizes the problematic statements with Optimize SQL or Batch Optimize SQL.
  • Inspect SGA – Captures, analyzes and classifies both running and executed SQL statements from Oracle SGA.  Send problematic statements to Optimize SQL or Batch Optimize SQL for optimization.
  • Analyze impact – Reviews the effect that database modifications may have on the SQL by identifying execution plan changes that could have occurred within a set of SQL statements. Collects SQL from a variety of sources, such as Oracle Automatic Workload Repository, Foglight Performance Analysis or source code.
  • Manage plans – Manages both Oracle Stored Outlines and SQL Plan Baselines, and allows you to refine execution plans without changing the source code. Stored Baselines are optimization hints that help maintain an execution plan for a SQL statement.

Specifications

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

Platform

1 GHz Processor

Memory

1 GB of RAM for SQL Optimizer for Oracle 32-bit

2 GB of RAM for SQL Optimizer for Oracle 64-bit

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

180 MB of disk space for SQL Optimizer for Oracle 32-bit

217 MB of disk space for SQL Optimizer for Oracle 64-bit

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 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 8.1 32-bit and 64-bit

Microsoft Windows 8.1 (with Update) 32-bit and 64-bit

Microsoft Windows Server 2012

Microsoft Windows Server 2012 R2

Microsoft Windows Server 2012 R2 (with Update)

.NET Framework

Microsoft .NET Framework 4.0 Full Profile

Browser

Microsoft Internet Explorer 6.0 or later

Note: Other browsers may also be used.

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

Oracle v9 Client (Net9)

Oracle v10 Client (Net10)

Oracle v11 Client (Net11)

Oracle 12c Client

Oracle Instant Client

Note: You must use the 32-bit version of SQL Optimizer if you use the 32-bit Oracle Client, and the 64-bit version of SQL Optimizer if you use the 64-bit Oracle 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.

Important: It is recommended that you use an Oracle Client of the same release/version (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

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
  • Microsoft Application Virtualization (App-V) 5.0 on Windows 7 and Windows Server 2012
Server Virtualization

SQL Optimizer has been tested with the following:

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

Language supported:

  • US English