去客户做oracle数据库巡检时发现有一些DBA_HIST_开头的无效对象：
DBA_HIST_FILESTATXS
DBA_HIST_SQLSTAT
DBA_HIST_SQLBIND
DBA_HIST_SYSTEM_EVENT
DBA_HIST_WAITSTAT
DBA_HIST_LATCH
DBA_HIST_LATCH_MISSES_SUMMAR
DBA_HIST_DB_CACHE_ADVICE
DBA_HIST_ROWCACHE_SUMMARY
DBA_HIST_SGASTAT
DBA_HIST_SYSSTAT
DBA_HIST_SYS_TIME_MODEL
DBA_HIST_OSSTAT
DBA_HIST_PARAMETER
DBA_HIST_SEG_STAT
DBA_HIST_ACTIVE_SESS_HISTORY
DBA_HIST_TABLESPACE_STAT
DBA_HIST_SERVICE_STAT
DBA_HIST_SERVICE_WAIT_CLASS
后来查找metalink原来是oracle的一个bug，不过对数据库影响不大，可以不去理会他。

DBA_HIST% Objects Become INVALID At Random [ID 312076.1]
		Modified 08-JUL-2009 Type PROBLEM Status PUBLISHED

In this Document
Symptoms

Solution

---

Applies to:

Oracle Server - Enterprise Edition
This problem can occur on any platform.
Fixed releases: patchset 10.2.0.3.0

Symptoms

The following set of objects become invalid in random:

DBA_HIST_FILESTATXS
DBA_HIST_LATCH
DBA_HIST_LATCH_MISSES_SUMMARY
DBA_HIST_DB_CACHE_ADVICE
DBA_HIST_ROWCACHE_SUMMARY
DBA_HIST_SGASTAT
DBA_HIST_SYSSTAT
DBA_HIST_SQLSTAT
DBA_HIST_SQLBIND
DBA_HIST_SYSTEM_EVENT
DBA_HIST_WAITSTAT
DBA_HIST_SYS_TIME_MODEL
DBA_HIST_OSSTAT
DBA_HIST_PARAMETER
DBA_HIST_SEG_STAT
DBA_HIST_ACTIVE_SESS_HISTORY
DBA_HIST_TABLESPACE_STAT
DBA_HIST_SERVICE_STAT
DBA_HIST_SERVICE_WAIT_CLASS
DBMS_SWRF_REPORT_INTERNAL
DBMS_SQLTUNE

At one moment there will not be any invalid objects in the database. All of a sudden you see the above list of invalid objects in the database.

Cause

The cause of this problem has been identified and verified in an
unpublished Bug 4077874 which is a duplicate of unpublished Base Bug 3603160.

These objects are based on underlying partitioned tables which keep system statistics as a history.
The invalidation is just when the underlying partitions are added/dropped which occurs automatically over time.

Solution

Unpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0
For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms.

Below is a list of available onoff patches for the following database versions and
platforms:

10.1.0.4.0 on HP-UX PA-RISC (64-bit)
10.1.0.5.0 on Solaris Operating System (SPARC 64-bit)
10.1.0.5.0 on Linux x86

10.2.0.2.0 on Linux x86-64 (AMD64/EM64T)
10.2.0.2.0 on Solaris Operating System (SPARC 64-bit)
10.2.0.2.0 on HP-UX PA-RISC (64-bit)
10.2.0.2.0 on AIX5L Based Systems (64-bit)

Please contact customer support to get the download information for a oneoff patch when needed.

Hence, you can choose to upgrade to the patchsets containing the fix or apply the one off fix, if it is available for your version and platform.

OR

You can also choose to ignore these invalid objects. When you access these objects they would become VALID again. They wouldn't cause any application failure.

References

NOTE:3603160.8 - Bug 3603160 - AWR should recompile SYS views after purge operation drops partitions

[@more@]