Welcome to Embarcadero® DB Optimizer™ 1.5.1

DB Optimizer Home | DB Optimizer Documentation | Embarcadero Technical Support | www.embarcadero.com


Thank you for using Embarcadero DB Optimizer, an enterprise SQL development and optimization tool that gives database developers and administrators the perfect environment for building the best performing SQL code. This application easily identifies inefficient SQL code and boosts developer productivity by ensuring SQL is right before it becomes a problem in mission-critical applications. DB Optimizer also provides a rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object validation tools. Lastly, DB Optimizer provides advanced project and data source management tools.

What's New in DB Optimizer 1.5

SQL Load Editor

Full Tuning Qualification of Objects

Command Line Tuning Execution

Interface Reorganization

Continous Monitoring of Data Sources

Track Top Activities

Statement, Event, and Session Drill Down Functionality

Cross Platform Data Source Support

Release Notes

DBMS Support

Important Advisory Notes

Known Issues

Installation Issues

Bug Fixes

What's New in DB Optimizer 1.5

SQL Load Editor

SQL Load Editor is a new view that enables you to configure and execute SQL code against a data source, and then run the execution process in the background while you perform a profiling session on the affected data source. This feature provides the ability to execute ad hoc code, or code from an existing SQL file, and enables you to configure the execution process to specify parameters such as number of users, the length that the execution process runs for (over a specific period of time, or by execution cycle), and if there is time between code execution cycles (a specified or random length.)

Full Tuning Qualification of Objects

DB Optimizer now fully qualifies objects in SQL code in order to support the tuning function of all queries discovered in a profiling session. This enables a DB Optimizer user to tune queries run by different users as long as the DB Optimizer user has select privileges on the underlying objects.

Command Line Tuning Execution

The ability to send execution commands to DB Optimizer's tuning function has been implemented in this release. The syntax and process through which you execute tuning jobs from the command line is similiar to the existing profiling functionality.

Interface Reorganization

DB Optimizer has been reorganized into three major interface pieces. This enhancement provides users with a more comprehensive workflow when analyzing queries across the enterprise, and provides more efficient task management in terms of time and efficiency, overall:

Continuous Monitoring of Data Sources

Profiling now enables the continuous monitoring of data sources by providing real time updates to the interface. This feature can be turned on and off via profiling configuration settings, and provides custom tweaking to suit machine efficiency with adjustable screen refresh rates in seconds.

Track Top Activities

The Track Top Activity Section enables users to examine more detailed information on waiting and executing sessions over the length of the session. When you select an item from the Top Activity Section, details about your selection appear in the Profiling Details view, automatically.

Statement, Event, and Session Drill Down Functionality

Using the Top Session and Profiling Details views, you can drill down into statements, events, and sessions that have been monitored by SQL profiling. This feature enables you to view and diagnose the underlying code in order to troubleshoot inefficient or otherwise not-ideal queries running on a data source.

Cross Platform Data Source Support

In addition to Oracle platforms, Tuning now supports Generic JDBC, IBM DB2 LUW, Microsoft SQL Server, and Sybase data sources. This enables more complete monitoring and tuning sessions that improve the efficiency of your entire enterprise. See the DBMS Support section of these release notes for a full and comprehensive list of supported DBMS platform types.

Release Notes

DBMS Support

Important Advisory Notes

Known Issues

Installation Issues

DB Optimizer 1.5 should be installed in a different directory than DB Optimizer 1.0. If Optimizer is installed in the same directory, the following error will result at application start up: "Unable to read workbench state. Workbench UI layout will be reset".

Additionally, DB Optimizer 1.5 should be installed in a different directory than previous Beta versions. If the beta version is already installed on your machine, either change the default Workspace or delete all files from the Workspace directory. The Workspace directory location appears in a prompt whenever you start Optimizer, and can be redefined from this dialog box. If the same Workspace is indicated for 1.5 as was indicated for the Beta, the following error will result: "Cannot restore workbench layout".

If Optimizer is already running, you can also modify the Workspace directory by choosing File > Switch Workspace > Other from the Main Menu.

Bug Fixes


Bugs fixed in DB Optimizer 1.5
Bug Description DBMS
OPT-1062 Product does not support tuning on _NOTFOUND. All
Bugs fixed in DB Optimizer 1.0.1
Bug Description DBMS
OPT-610 Improve Sybase collection to capture more events and filter out fewer events. Sybase
OPT-609 Improve Oracle collection and reduce target load to 1%. Also reduce connected user requirement from SYS down to any user granted SELECT_CATALOG_ROLE. Oracle
OPT-611 Fix the issue that could cause "static" charts or application crashes on some client machines. Also change chart bar interval to 5 seconds for improved data display. All
OPT-612 Add some enhanced error logging and collection diagnostics (activated with -Ddebug=true in dboptimizer.ini). All
OPT-673 Remove the empty Oracle statistics drilldown tab. Oracle
Bugs Fixed in Embarcadero DB Optimizer 1.0
TAL-6653 We aren't closing the connections to the database when a SQL editor window is closed All
TAL-6700 Multiple database connections All
SQL-1494 Update keyword inappropriately flagged as unexpected token in PowerSQL trigger Sybase and SQL Server
SQL-1486 Parser reporting an error on correct SQL Sybase

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact sales@embarcadero.com, or uk.sales@embarcadero.com for sales in the EMEA region.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, FAQs, discussion groups, and the Embarcadero KnowledgeBase. Go to www.embarcadero.com/resources, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.