Invalid SYS Owned Objects SYS.GV$PARAMETER_CBO cannot be compiled (Doc ID 2915415.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

The dba_objects show the object below as invalid:

Invalid sys object:

OWNER OBJECT_NAME OBJECT_TYPE
------------ ---------------------------------------- ----------------------------------------
SYS GV$PARAMETER_CBO VIEW

Trying to recompile manually encountered the error below:

SQL> show user;
USER is "SYS"
SQL> ALTER VIEW GV$PARAMETER_CBO COMPILE;
ALTER VIEW GV$PARAMETER_CBO COMPILE
*
ERROR at line 1:
ORA-00999: invalid view name

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.