Invalid SYS views: Q$BH And Q$BUFFER_CACHE (Doc ID 730338.1)

Last updated on MARCH 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
The following views are marked invalid and not able to validate them: Q$BH And Q$BUFFER_CACHE

SQL> select object_name,object_type,status from dba_objects where owner = 'SYS' and status = 'INVALID';

OBJECT_NAME
OBJECT_TYPE
STATUS
------------------
Q$BUFFER_CACHE
VIEW
INVALID

Q$BH
VIEW
INVALID

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms