Oracle Invalid Objects Report
This script lists all invalid database objects. It queries the DBA_OBJECTS view to display object owner, type, name, and status, helping DBAs and developers identify objects that require recompilation or troubleshooting.
oraclesqlmonitoring-alertsv1.0.0
0 stars0 downloads16 views0 comments
By OracleDba • Created
Code
(18 lines)123456789101112131415161718
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/invalid_objects.sql
-- Author : Tim Hall
-- Description : Lists all invalid objects in the database.
-- Call Syntax : @invalid_objects
-- Requirements : Access to the DBA views.
-- Last Modified: 18/12/2005
-- -----------------------------------------------------------------------------------
COLUMN owner FORMAT A30
COLUMN object_name FORMAT A30
SELECT owner,
object_type,
object_name,
status
FROM dba_objects
WHERE status = 'INVALID'
ORDER BY owner, object_type, object_name;