I am trying to understand which lines in DBA_FEATURE_USAGE_STATISTICS correspond to Diagnostics and Tuning Pack features.
This view contains data for separately licensed features (like Partitioning and Spatial) and for features that don't require separate license (like Server Parameter File and Shared Server).
For Spatial there is only one line (name = 'Spatial') so there is no confusion. For Partitioning there is a line with name = 'Partitioning (system)' - I assume this means partitioning used internally by AWR, it doesn't require Partitioning license. There is also line with name = 'Partitioning (user)', it requires license.
There are multiple lines that may be related to Diagnostics and Tuning packs, for example:
AWR Baseline
AWR Baseline Template
AWR Report
Automatic Maintenance - SQL Tuning Advisor
Automatic SQL Tuning Advisor
Automatic Workload Repository
Is there a document that lists lines in DBA_FEATURE_USAGE_STATISTICS that correspond to Diagnostics and Tuning Packs? For example, we have a database where
Detected_Usages = 0 for 'Diagnostic Pack' and 'Tuning Pack', but Detected_Usages = 2 for 'AWR Report'. Does it mean it needs a license?