Database Administration (MOSC)

MOSC Banner

18c - DBA_HIST_FILESTATXS and DBA_HIST_TEMPSTATXS are empty

edited Sep 16, 2020 8:56PM in Database Administration (MOSC) 6 commentsAnswered ✓

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center