Diagnostics Pack license:
The Analyze impact and Optimize Indexes features of SQL Optimizer support retrieving SQL from AWR. This function will access AWR, therefore, it requires users to have the Diagnostic Pack license. SQL Optimizer will not actually verify the needed license, however, it will prompt users to confirm if they have the license. See attached. Users can also change the setting of the warning message by the Options window.
Tuning Pack license:
The Deploy feature of SQL plans does not use the SQL Tuning license. Hence, SQL Optimizer does not require this license.
Enterprise Edition license:
The SQL Baseline feature is not in Oracle Standard Edition. Therefore, if users move from Enterprise Edition to Base Edition, then users will not be able to use Plan Control and Baseline Manager in SQL Optimizer.
