Welcome to Embarcadero® DB Optimizer™ 3.6/XE3.5
Last Updated: February 8, 2013
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 3.6/XE3.5
Connectivity/Data Source
Profiling Updates
Tuning Updates
System Requirements
Hardware Requirements
Supported Operating Systems
Other Requirements
DBMS Support
SQL Execution, Tuning and DBMS Support
SQL Profiling and DBMS Support
Release Notes
Upgrade Notes
Bug Fixes
What's New in DB Optimizer 3.6/XE3.5
Connectivity/Data Source
- Custom Data Source Categories - In previous releases, when assigning a category to a data source,
your choices were restricted to a set of default categories: Development, Production, Test, and QA.
You can now create your own custom categories, providing a category name, short name, and identifying color for each.
Profiling
- Oracle Procedures Load Details - When profiling against an Oracle (10g or higher) data source,
the Top Activity area and the Profiling Details pane now have deidcated Procedures tabs that provide information about the procedures load on the data source.
- Oracle Blockers Tab - A new profiling tab provides details on blocking sessions.
Tuning
- DB2 9.7 Execution Statistics - When tuning against a DB2 9.7 data source,
the Overview tab, the Generated Cases area now includes additional sets of statistics gathered for the suggested cases.
Available statistics now include Elapsed Time, Result, Rows Returned, Physical Reads, Logical Reads, CPU Time,
Direct Reads, Sorts, Sort Time, and Sort Overflows.
- New SQL Server Analysis Tabs -
When tuning against a SQL Server data source, additional statistics are available on the new
Table Statistics and Column Statistics and Histograms tabs.
A new Plan Guides tab is also available.
- Oracle Database Links - This release introduces improved support for tuning of statements referencing DBLINK objects.
- Oracle OPTIMIZER_FEATURES_ENABLE hint - Lets you enable Optimizer features for a specified Oracle release.
- Oracle 11g R1 and R2 hints - DB Optimizer tuning now supports the USE_INVISIBLE_INDEXES,
NO_USE_INVISIBLE_INDEXES, INDEX_RS_ASC, INDEX_RS_DESC, IGNORE_ROW_ON_DUPKEY_INDEX,
BIND_AWARE, NO_BIND_AWARE, NO_RESULT_CACHE, RESULT_CACHE, NO_STATEMENT_QUEUING,
and STATEMENT_QUEUING hints.
- Oracle 10g R2 hints - DB Optimizer tuning now supports the USE_HASH_AGGREGATION, NO_USE_HASH_AGGREGATION,
NATIVE_FULL_OUTER_JOIN, NO_NATIVE_FULL_OUTER_JOIN, NO_XML_DML_REWRITE, and PRECOMPUTE_SUBQUERY hints.
- New SQL Server Table Hints -
Two new table hints are now available against SQL Server 2008 data sources.
FORCESEEK forces the optimizer to use an index seek operation as the access path to the referenced table or view.
FORCESCAN forces the optimizer to use an index scan operation as the access path to the referenced table or view.
System Requirements
Before installing EmbarcaderoŽ DB Optimizer, verify that your environment meets the following requirements.
Hardware Requirements
The following are the minimum hardware requirements:
- Pentium 4-Level Processor
- 1 GB of memory
- 1 GB of disk space
- 1024 x 768 screen resolution
Supported Operating Systems
DB Optimizer is supported on the following operating systems:
- Windows 8
- Microsoft Windows 7, 32 and 64 bit
- Microsoft Windows Server 2008, 32 and 64 bit
- Microsoft Windows Vista, 32 and 64 bit
- Microsoft Windows XP, 32 and 64 bit
- Microsoft Windows 2003
- Linux, x86-32, GTK 2
- Red Hat Enterprise Linux 5.0
- SuSe Linux Enterprise Server 10
Other Requirements
DB Optimizer requires a Java6 VM to run:
- Windows XP/Vista/2003 Sun Java 2 Standard Edition 6 Update 29 for Microsoft Windows
- Linux: Sun Java 2 Standard Edition 6 Update 27 for Linux x86
- DB Optimizer can be installed as a standalone application (RCP installation) or as an Eclipse plug-in (plug-in installation).
- The Eclipse plug-in version of DB Optimizer requires Eclipse version 3.6 or higher and Sun Java Standard Edition 6
(with the Windows-specific or Linux-specific Update specified in the first two points) in addition to regular system requirements. Before installing the plug-in version of DB Optimizer, ensure that Eclipse and Java are installed on your machine. You can download Eclipse from the following Web site: www.eclipse.org/downloads.
DBMS Support
SQL Execution, Tuning and DBMS Support
SQL execution and SQL tuning with DB Optimizer is supported on the following DBMS platforms and versions:
- Oracle (9i - 11g)
- Sybase (12.5 - 15.x)
- IBM DB2 for LUW (8.0 - 9.x)
- MS SQL Server (2000, 2005, 2008 R2)
- JDBC (execution only)
SQL Profiling and DBMS Support
SQL profiling with DB Optimizer is supported on the following DBMS platforms and versions:
- Oracle (9i - 11g)
- Sybase (12.5.0.3 - 15.x)
- IBM DB2 for LUW (8.2 - 9.x)
- MS SQL Server (*2000 SP3, 2005, 2008 R2)
* On Microsoft SQL Server 2000, the Profiling feature is only supported if Service Pack 3 (SP3) is installed.
Note: DB Optimizer does not access in any way, shape or form any of the information, tables or views licensed under Oracle's diagnostic pack.
Release Notes
Upgrade Notes
- DB Optimizer should be installed in a different directory than previous versions of DB Optimizer. If DB Optimizer is installed in the same directory, the following error will result in at application start up: "Unable to read workbench state. Workbench UI layout will be reset.
- If a previous 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 whenever you start Optimizer, and can be redefined from this dialog box. If the same Workspace is indicated for the new version as was indicated previously, the following error will result: "Cannot restore workbench layout".
- If DB/Optimizer is already running, you can also modify the Workspace directory by choosing File > Switch Workspace > Other from the Main Menu.
- We strongly suggest selecting a new workspace when upgrading from a previous version of DB Optimizer.
- Saved profiling and tuning session files (.oar) created using previous versions of DB Optimizer are not compatible with current versions. You can however have more than one version of DB Optimizer installed on the same system. To read old .oar files, run the older version of DB Optimizer.
Bug Fixes
Bugs Fixed in DB Optimizer 3.6/XE3.5 |
OPT-2957
|
ORA-01795: maximum number of expressions in a list is 1000.
|
OPT-3084
|
SQL_PARSER to support DB2 LUW v9.7 "round(max(a.miktar), 0) as miktar" statement.
|
OPT-3455
|
DB Optimizer 3.5 can't launch on Windows 2008 Server R2
|
OPT-3537
|
TS: [Tuning Job] - Error "Could not retrieve the object" returned by tuning job against a DB2 partitioned database
|
Embarcadero Technologies Technical Support
If you have a valid maintenance contract with Embarcadero Technologies, our Support team will 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. To download evaluations of Embarcadero Technologies products go to the www.embarcadero.com.
To contact Support, go to Support.