Oracle periodic monitoring 2: user object Status Monitoring

In the process of running Oracle, for various reasons, some objects, such as stored procedures and functions, are as follows:

SQL> select distinct object_type from all_objects;

Object_type
------------------
Cluster
Consumer group
Context
Evaluation Context
Function
Index
Index Partition
Library
Lob
Operator
Package

Package body
Procedure
Queue
Resource plan
Sequence
Synonym
Table
Table Partition
Trigger
Type
Type Body
View

23 rows have been selected.

The status of the above objects is sometimes changed to invalid. If you do not pay attention to the monitoring, it sometimes affects production and use.

SQL> select object_name, object_type, status from all_objects where status = 'invalid ';

You can use the following statements to Monitor Invalid objects of databases or users:

View invalid user objects from dba_objects:

SQL> select object_name, object_type, status from dba_objects where status = 'invalid ';

View invalid user objects from the current user:

SQL> select object_name, object_type, status from user_objects where status = 'invalid ';

If an invalid object is found, it must be implemented in a timely manner. For example, stored procedures, packages, and functions can be re-compiled and views must be re-built!