Chat now with support
Chat with Support

SQL Optimizer for Oracle 9.2.3 - Release Notes

System Requirements

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

Requirement Details

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 2008 R2

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 R1

Microsoft Windows Server 2012 R2

Microsoft Windows Server 2012 R2 (with Update)

Microsoft Windows 10 32-bit and 64-bit

Microsoft Windows Server 2016

.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 Viewer Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide)
Database Client

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 10g R2, 11g R1, 11g R2, 12c Release 1, 12c Release 2

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 Service

Oracle Database as a Service

Oracle databases running on Amazon EC2, Amazon RDS, and Microsoft Azure

Virtualization Support

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

Type Details
Application Virtualization

SQL Optimizer has been tested with the following:

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

 

Product Licensing

Product Licensing

To activate a trial license

  1. Enter the Authorization Key included in your Trial Email into the License Key field of the License dialog.
  2. Enter the Site Message included with your Authorization Key.

To activate a purchased commercial license

  1. Enter the Authorization Key included in your Purchase Email into the License Key field of the License dialog.
  2. Enter the Site Message included with your Authorization Key.

Getting Started with SQL Optimizer

Contents of the Release Package

The SQL Optimizer for Oracle release package contains the following products:

  1. SQL Optimizer for Oracle
  2. Product Documentation, including:
    • Installation Guide
    • User Guide
    • Online Help, which includes tutorials

Installation Instructions

Refer to the SQL Optimizer for Oracle Installation Guide for installation instructions.

Upgrade from Previous Release

SQL Optimizer 8.7 (or later) does not support an upgrade from the 32-bit version to the 64-bit version (or 64-bit to 32-bit). To upgrade from the 32-bit version of SQL Optimizer to the 64-bit version, please uninstall the previous 32-bit version. See ST102226 in the Known Issues section for more information.

Note: SQL Optimizer 8.7 (or later) supports side-by-side installation of versions with different "bitness" as long as they are also different releases (e.g., 8.6 and 8.7) or different editions (e.g., Commercial and Trial).

Globalization

Globalization

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

The release is localized to the following languages: Chinese (Simplified), Korean.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating