Stop and Resume the Optimization Process (SQL Rewrite)
- This release of SQL Optimizer includes an exciting new enhancement to the Optimize SQL workflow. You can now interrupt the optimization process without losing the SQL alternatives and test run results generated thus far in your SQL Rewrite session. This is useful if you need to close SQL Optimizer or shut down your computer in the middle of a long-running optimization session. When it is convenient, reopen the saved session and resume running the optimization process, beginning from the point where it was interrupted.
- Another important workflow enhancement enabled by this new feature is the ability to increase the intelligence level in the middle of an optimization process. If you find that the current intelligence level is not generating better or sufficient alternatives, you can stop the process, increase the level, and then resume the process. SQL Optimizer will use increased quotas and hints to find additional alternatives without losing the alternatives and results generated thus far.
Note: This new feature is available for SQL Rewrite sessions only. It is not available for Plan Control sessions
at this time.
Test Run Untested Alternatives (SQL Rewrite)
- The Test Run button now includes a new command, Test Run - Non-Tested. Use this command to test run
SQL alternatives that have never been tested. This is useful if you paused the optimization process during the test run phase.
Note: This new feature is available for SQL Rewrite sessions only. It is not available for Plan Control sessions at this time.
-Enhancements to the Test Run Different Bind Values feature. This feature was introduced in SQL Optimizer 9.1 and can be used when optimizing a SQL statement that includes a least one bind variable.
-Bind value source. A new column in the Bind Values page identifies the source of the bind value. In
addition, when you modify the list of bind values, new entries are highlighted green.
-Auto Fill finds all available values from Oracle. When you click the Auto Fill button to retrieve bind
values from Oracle, all available bind value sets captured by Oracle are now retrieved. In the previous
release, only the latest set of bind values captured by Oracle was retrieved. The Bind Variables Values grid
is automatically populated with any value sets found that are not currently listed in the grid.
-For testing alternatives using bind value sets, you can now specify a default value for the SQL termination
option Percentage of original SQL total run time available in the Test Run Settings dialog.
Execution Plan
- Display DBMS_XPLAN as plain text. You can now display execution plans using the DBMS_XPLAN in plain
text format. This is the format returned from Oracle.
- Save plan as text file. You can now save an execution plan as a text file. This feature is available for the
DBMS_XPlan formats.
*******
Additional information relating to the new features in version 9.2.1 can be found in the SQL Optimizer for Oracle Release Notes or in the 'New in this release' of the Help. (includes instructions and screenshots)