exec dbms_stats.

gather_table_stats('SYSTEM','DBA_FEATURE_USAGE_STATISTICS');
dba_feature_usage_statistics

Revisar el uso de caracteristicas en la BD

=================================================
En general
=================================================

select name
, detected_usages
from dba_feature_usage_statistics
where detected_usages > 0
/

NAME DETECTED_USAGES

----------------------------------------------- ----------------
Traditional Audit 54
Unified Audit 55
Automatic Maintenance - Space Advisor 55
Automatic Maintenance - SQL Tuning Advisor 55
Automatic Segment Space Management (system) 55
Automatic SQL Execution Memory 5
Automatic Undo Management 55
Data Guard 2
Dynamic SGA 1
Flashback Database 7
Deferred Segment Creation 55
Locally Managed Tablespaces (system) 55
Automatic Memory Tuning 50
Automatic SGA Tuning 5
Recovery Manager (RMAN) 9
RMAN - Disk Backup 9
Backup BASIC Compression 2
Active Data Guard - Real-Time Query on Physical Standby 2
Duplicate Db from Active Db using BackupSet 7
Server Parameter File 54
Shared Server 1
Real Application Security 55
Automatic Maintenance - Optimizer Statistics Gathering 55
Automatic Segment Space Management (user) 54
Character Set 55
Locally Managed Tablespaces (user) 55
Partitioning (system) 55
Recovery Area 55
Automatic SQL Tuning Advisor 52
Adaptive Plans 55
Automatic Reoptimization 55
SQL Plan Directive 55
DBMS_STATS Incremental Maintenance 55
Oracle Utility Datapump (Export) 3
Oracle Utility Metadata API 4
Oracle Utility External Table (ORACLE_LOADER) 31
Result Cache 2
Services 7
SecureFiles (user) 55
SecureFiles (system) 55
Job Scheduler 48
Oracle Java Virtual Machine (system) 55
Real-Time SQL Monitoring 55

=============================
Solo tuning pack
=============================

col c1 heading 'Feature Name' format a35

col c2 heading 'Detected|Usages' format 999,999
col c3 heading 'Last|Usage|Date' format a10
select
name c1,
detected_usages c2,
last_usage_date c3
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;

Last
Detected Usage
Feature Name Usages Date
----------------------------------- -------- ----------
ADDM 0
Automatic SQL Tuning Advisor 52 24/02/20
Automatic Workload Repository 0
AWR Baseline 0
AWR Baseline Template 0
AWR Report 0
EM Performance Page 0
Real-Time SQL Monitoring 55 24/02/20
SQL Access Advisor 0
SQL Monitoring and Tuning pages 0
SQL Performance Analyzer 0
SQL Tuning Advisor 0
SQL Tuning Set (system) 0
SQL Tuning Set (user) 0

Despues ejecute un AWR pero aun así no se actualizaba la tabla

por lo que se actualizó de forma manual

How to Manually Refresh Dba_feature_usage_statistics (Doc ID 1629485.1)

Te conectas como sys y arrojas el siguiente comando

connect / as sysdba
alter session set "_SWRF_TEST_ACTION"=53;
alter session set NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';
select MAX(LAST_SAMPLE_DATE) from dba_feature_usage_statistics;

Y se volvio a consultar

Last
Detected Usage
Feature Name Usages Date
----------------------------------- -------- --------
ADDM 1 27/02/20
Automatic SQL Tuning Advisor 53 27/02/20
Automatic Workload Repository 0
AWR Baseline 0
AWR Baseline Template 0
AWR Report 1 27/02/20
EM Performance Page 0
Real-Time SQL Monitoring 56 27/02/20
SQL Access Advisor 0
SQL Monitoring and Tuning pages 0
SQL Performance Analyzer 0
SQL Tuning Advisor 0
SQL Tuning Set (system) 0
SQL Tuning Set (user) 0

NAME
DETECTED_USAGES
------------------------------------------------------------- ---------------
ADDM
1
Traditional Audit
 55
Unified Audit
56
Automatic Maintenance - Space Advisor
56
Automatic Maintenance - SQL Tuning Advisor
56
Automatic Segment Space Management (system)
56
Automatic SQL Execution Memory
5
Automatic Undo Management
56
Data Guard
3
Dynamic SGA
1
Flashback Database
8
Deferred Segment Creation
56
Locally Managed Tablespaces (system)
56
Automatic Memory Tuning
51
Automatic SGA Tuning
5
Recovery Manager (RMAN)
9
RMAN - Disk Backup
9
Backup BASIC Compression 2
Active Data Guard - Real-Time Query on Physical Standby 3
Duplicate Db from Active Db using BackupSet
8
Server Parameter File
55
Shared Server
1
Real Application Security
56
Automatic Maintenance - Optimizer Statistics Gathering
56
Automatic Segment Space Management (user)
55
AWR Report
1
Character Set
56
Locally Managed Tablespaces (user)
56
Partitioning (system)
56
Recovery Area
56
Automatic SQL Tuning Advisor
53
Adaptive Plans
56
Automatic Reoptimization
56
SQL Plan Directive
56
DBMS_STATS Incremental Maintenance
56
Oracle Utility Datapump (Export)
3
Oracle Utility Metadata API
4
Oracle Utility External Table (ORACLE_LOADER)
31
Result Cache
2
Services
8
SecureFiles (user)
56
SecureFiles (system)
56
Job Scheduler
49
Oracle Java Virtual Machine (system)
56
Real-Time SQL Monitoring
56