check what features are there in the database

##########################################
dba_feature_usage_statistics
##########################################

check what features are there in the database

select name, detected_usages, last_usage_date, last_sample_date from dba_feature_usage_statistics;

select name, detected_usages, last_usage_date, last_sample_date
from dba_feature_usage_statistics
where name in (
    'ADDM', 'Automatic SQL Tuning Advisor', 'Automatic Workload Repository',
    'AWR Baseline', 'AWR Baseline Template', 'AWR Report', 'EM Performance Page',
    'Real-Time SQL Monitoring', 'SQL Access Advisor',
    'SQL Monitoring and Tuning pages', 'SQL Performance Analyzer',
    'SQL Tuning Advisor', 'SQL Tuning Set (system)', 'SQL Tuning Set (user)'
)
order by name;