Oracle Schema Object Status Report
Displays database objects and their status for a specified schema. Useful for identifying invalid objects that may require recompilation or troubleshooting.
oraclesqlmonitoring-alertsv1.0.0
0 stars0 downloads12 views0 comments
By OracleDba • Created
Code
(23 lines)1234567891011121314151617181920212223
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/object_status.sql
-- Author : Tim Hall
-- Description : Displays a list of objects and their status for the specific schema.
-- Requirements : Access to the ALL views.
-- Call Syntax : @object_status (schema-name)
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET SERVEROUTPUT ON
SET PAGESIZE 1000
SET LINESIZE 255
SET FEEDBACK OFF
SET VERIFY OFF
SELECT Substr(object_name,1,30) object_name,
object_type,
status
FROM all_objects
WHERE owner = Upper('&&1');
PROMPT
SET FEEDBACK ON
SET PAGESIZE 18