Toad World® Forums

Spotlight on Oracle - Diagnostic and Tuning Pack (?)


I have Oracle SE, 11R2.
could I have clear answer - if using Spotlight is related with any risk of not passing Oracle Audit ?

Does Spotlight eg. shows warn messages if I would click any option related to AWR ?
Could options related to paid Oracle features be disabled ?

Best regards,


Hello - if you are using Oracle Standard Edition you will not be able to use AWR since it is only available in Diagnostic & Tuning Pack which an Enterprise Edition option.

That said - Spotlight on Oracle does not use AWR features by default. There are AWR drilldown tabs that can be enabled by the user through modifying a configuration file.