18c - DBA_HIST_FILESTATXS and DBA_HIST_TEMPSTATXS are empty
Hello, I noticed unexpected behavior in our 18c databases that the DBA_HIST_FILESTATXS and DBA_HIST_TEMPSTATXS are empty.
In other databases that are in 11g we do not have this issue.
The respective V$ have records.
SQL> select count(*) from DBA_HIST_FILESTATXS;
COUNT(*)
----------
0
SQL> select count(*) from DBA_HIST_TEMPSTATXS;
COUNT(*)
----------
0
SQL> select count(*) from V$FILESTAT;
COUNT(*)
----------
46
SQL> select count(*) from V$TEMPSTAT;
COUNT(*)
----------
7
I checked that they are in valid status:
SQL> select owner, object_name, object_type, status from dba_objects where object_name in ('DBA_HIST_FILESTATXS','DBA_HIST_TEMPSTATXS');