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
Full Tuning Qualification of Objects
Continous Monitoring of Data Sources
Statement, Event, and Session Drill Down Functionality
Cross Platform Data Source Support
Release Notes
What's New in DB Optimizer 1.5
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.
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.
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.
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
| 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 [email protected], or [email protected] 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.