Chat now with support
Chat with Support

SQL Optimizer for Oracle 10.0 - Release Notes

Release Notes

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

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating