Chat now with support
Chat with Support

SQL Optimizer for Oracle 10.0 - Release Notes

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature Known Issue Defect ID
Inspect SGA SQL Optimizer for Oracle is not processing the request when users submit the completed Inspect SGA job for batch optimization. SOFO-2880
Optimize SQL SQL Optimizer for Oracle is unable to search for alternatives when optimizing SQL with nested queries by retrieving all records from the table. SOFO-2879
Optimize SQL The SQL Optimizer for Oracle translates some words into Korean incorrectly in the Optimize SQL's report. SOFO-2876
Optimize Index, Optimize SQL There is performance slowness observed when executing Optimize Index and Optimize SQL operations on medium, complex, and simple queries. SOFO-2875
Inspect SGA After adding a future job in the Inspect SGA module, users are unable to close the application. SOFO-2873
Optimize SQL SQL Optimizer for Oracle displays the This type of SQL statement is not supported error when users attempt to optimize a query containing the JSON_OBJECT function. SOFO-2849
Optimize SQL The SQL Optimizer for Oracle application crashes when users click the Cancel button on the Optimize SQL Resolution report. SOFO-2834
Optimize SQL

The SQL Optimizer for Oracle is not identifying a statement with a query that contains pivot columns. For additional details, see https://support.quest.com/kb/4221548/error-optimizing-a-valid-query-the-parser-did-not-identify-the-text-as-a-valid-sql-statement-

 SOFO-2815
General

SQL Optimizer cannot test run in Exadata DB with 19c client.

Workaround:

User can use other client to connect to Exadata.

 SOFO-2628
General SQL Optimizer for Oracle displays an error when updating the Oracle database connection from version 11GR2 or 12C to 18C on the Migration tab. SOFO-2435
Scan SQL and
Batch Optimize		 When you select the "Include Dependants" option while scanning database objects, only first level dependents are retrieved instead of all dependents.

ST40625

Connecting
to Database

When the directory where SQL Optimizer is installed has a directory path which contains parenthesis, connecting to Oracle fails when using a pre-11g client.

This is a known Oracle issue that we cannot fix. This problem is more common in 64-bit environment because the default directory for 32-bit applications is "C:\Program Files (x86)\".

Workaround:

Install SQL Optimizer in a directory that does not have parenthesis or upgrade the Oracle client to 11g.

ST63421

Installation If you install SQL Optimizer version 8.8.1 (or later) and then do a side-by-side install of version 8.8.0, version 8.8.0 will fail to launch after it is successfully installed.

ST111404

Installation

If you install SQL Optimizer 8.8.0 (or later) side-by-side with version 8.7.0, then uninstall version 8.7.0, version 8.8.0 (or later) will no longer integrate with other Toad products. This issue is found in side-by-side installations of 8.8 and either 8.5.0, 8.6.0, 8.7.0, or 8.7.1 that are of the same edition (i.e., both Commercial edition) and the same bitness (i.e., both 32-bit).

Workaround 1: Launch SQL Optimizer 8.8.0 (or later) from the short-cut on the Start menu.

Workaround 2: Uninstall SQL Optimizer 8.8.0 (or later) and reinstall it.

ST109347

Installation

Background: SQL Optimizer 8.7 (or later) does not support an upgrade from the 32-bit version to the 64-bit version (or 64-bit version to 32-bit version). If you attempt to upgrade by using the Quest Software Installer, you will receive the appropriate warning message and the installation will not proceed.

Issue: If you attempt to upgrade from the 32-bit version of SQL Optimizer to the 64-bit version (or from the 64-bit version to the 32-bit version) by using the .msi installer, you will not receive a warning message and the installation will appear to proceed. However, you will encounter an error upon launching the upgraded application.

Workaround: To upgrade to a newer version of SQL Optimizer that has a different "bitness" (i.e., from 32-bit to 64-bit), you must first uninstall the previous version.

ST102226

Installation

A shortcut is not created in the Metro UI on Windows 8 and Windows Server 2012 for limited users in the following cases (when application is installed "for everyone"):

  • For a user that has never previously logged-in
  • For a new user created after installation

ST105153

Installation

A shortcut is not created in the Windows Start menu for limited users when upgrading or performing a side-by-side installation of SQL Optimizer 8.5 or later.

Workaround:

Launch SQL Optimizer from Windows Explorer.

ST76887

Installation

The CPM product key is not automatically entered when upgrading or performing a side-by-side installation of SQL Optimizer 7.5 or later.

Workaround:

Manually enter CPM product key in licensing window.

ST73191

Report

Unicode characters do not display correctly in the generated report.

Workaround:

For PDF: Select a font that contains the specific Unicode characters. Do this by modifying the font settings that apply to data grids and generated reports.

  1. Select Options | General | Appearance.

  2. Under Font Settings, in the Other Data drop-down list, select a font that contains the Unicode characters (for example, Arial Unicode MS).

For HTML and MHT: When exporting the report, select a Character set that contains the Unicode characters.

For CSV and Text: When exporting the report, select an Encoding option that supports the Unicode characters.

ST102639

Help Currently, you cannot enter Unicode characters in the Index or Search fields of the online help.

ST71331

When searching the online help for information using the Search bar in SQL Optimizer, topics display in the help window for exact matches found but the related index entry is not highlighted.

ST71433

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

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

Microsoft Windows 10 32-bit and 64-bit

Microsoft Windows 11 32-bit and 64-bit

Microsoft Windows Server 2012 R2

Microsoft Windows Server 2012 R2 (with Update)

Microsoft Windows Server 2016

Microsoft Windows Server 2019

Microsoft Windows Server 2022

.NET Framework

Microsoft .NET Framework 4.6.2 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 18c Client

Oracle 19c Client

Oracle 21c 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, 18c, 19c, 21c

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

Oracle AWS/RDS

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating