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"):
|
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.
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 |
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:
|
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 |
Before installing SQL Optimizer for Oracle®, review the following for virtualization support:
Type | Details |
---|---|
Application Virtualization |
SQL Optimizer has been tested with the following:
|
Server Virtualization |
SQL Optimizer has been tested with the following:
|
Note: SQL Optimizer may work in virtualization environments other than the ones in which it was tested. |
The SQL Optimizer for Oracle release package contains the following products:
Refer to the SQL Optimizer for Oracle Installation Guide for installation instructions.
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).
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center