SQL Optimizer for Oracle 10.0

Release Notes

Tuesday, January 9, 2024

About SQL Optimizer for Oracle

SQL Optimizer for Oracle automates the SQL optimization process and maximizes the performance of your SQL statements. SQL Optimizer analyzes, rewrites, and evaluates SQL statements located within database objects, files, or collections of SQL statements from Oracle's System Global Area (SGA). Once SQL Optimizer identifies problematic SQL statements, it optimizes the SQL and provides replacement code that includes the optimized statement.

SQL Optimizer also provides a complete index optimization and plan change analysis solution. It provides index recommendations for multiple SQL statements or a SQL workload, simulates index impact analysis, and generates SQL execution plan alternatives.

New Features

SQL Optimizer for Oracle 10

Database and platform support:

Oracle 21c
Oracle 21c Client
Windows 11
Windows Server 2022

Learn More

Remember, you can find blogs, videos, and forums at the SQL Optimizer for Oracle Community.

Find answers to your questions in the SQL Optimizer forums.
Learn tips and tricks from blog posts.

Discontinued Features

This release does not include any discontinued features.

Resolved Issues

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of SQL Optimizer for Oracle.

Resolved Issues in 10.0

Feature	Resolved Issue	Defect ID
General	The DevExpress Library has been upgraded from version 19.2.6 to 19.2.14.	SOFO-2833
Inspect SGA	SQL Optimizer for Oracle is displaying the Column ‘AvailableColumn’ does not belong to table tbDisplayColumn error when users attempt to select a column under the Available Column section in the Statistics steps of Inspecting SGA.	SOFO-2829
Optimize SQL	SQL Optimizer for Oracle is displaying incorrect Korean words in the report of Optimize SQL.	SOFO-2828
Inspect SGA	SQL Optimizer for Oracle is displaying the The selected Inspect time is passed error when users attempt to select the date and time to collect SQL statements in Inspect SGA.	SOFO-2827
Optimize SQL	When users execute a complex query in SQL Optimizer for Oracle, the application hangs and continues running indefinitely.	SOFO-2823/SOFO-2826
General	The product trial page is not automatically generating the trial license key after downloading the SQL Optimizer for Oracle application.	SOFO-2821
Manage Plans	Users are not able to use Baseline Management functionality under the Manage Plans options tab in the RDS environment.	SOFO-2817
Manage Plans	Users are not able to use Outline Management functionality under the Manage Plans options tab in the RDS environment.	SOFO-2816
Connection Manager	The SQL Optimizer for Oracle is not retrieving details from the tnsnames.ora file located on the network-mounted drive to populate database names under the Connection Manager > TNS tab.	SOFO-2729
Options	SQL Optimizer for Oracle displays the FTP Browse Error (No known hosts) error when users attempt to make configuration-related changes using the FTP access method in the Trace Setup window.	SOFO-2728
Options	SQL Optimizer for Oracle displays the ORA 29280 error when users attempts to make configuration related changes using the UTL_FILE access method on the Trace Setup window.	SOFO-2727
Options	SQL Optimizer for Oracle is not saving the options configured while setting up UTL_FILE in TraceSetup. As a result, the system is not displaying trace statistics information about SQL execution, such as IO, Buffer, and CPU Trace.	SOFO-2725
Manage Plans	SQL Optimizer for Oracle displays the ORA-15705: staging table does not exist when importing a baseline from a file error while reading the staging table name from a log file.	SOFO-2705

Herramientas de autoservicio: Base de conocimientos; Notificaciones y alertas; Soporte de productos; Descargas de software; Documentación técnica; Foros de usuarios; Tutoriales en video; Aviso de actualizaciones de páginas web (RSS)

Comuníquese con nosotros: Obtenga asistencia con las licencias; Soporte Técnico; Ver todos

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.