To Check the Last Compiled DB Objects and its Status
To know the Last Compiled DB Objects and Its Status
SELECT object_name, status, LAST_DDL_TIME,TIMESTAMP
FROM dba_objects
WHERE 1=1
AND owner IN ('APPS', 'XX')
AND TRUNC (LAST_DDL_TIME) = TRUNC (SYSDATE)
AND object_name LIKE '%XX%';
SELECT OWNER,object_name, status, LAST_DDL_TIME,TIMESTAMP
FROM all_objects
WHERE 1=1
AND owner IN ('APPS', 'XX')
AND TRUNC (LAST_DDL_TIME) = TRUNC (SYSDATE-5)
AND object_name LIKE '%XX%';
SELECT object_name, status, LAST_DDL_TIME,TIMESTAMP
FROM dba_objects
WHERE 1=1
AND owner IN ('APPS', 'XX')
AND TRUNC (LAST_DDL_TIME) = TRUNC (SYSDATE)
AND object_name LIKE '%XX%';
SELECT OWNER,object_name, status, LAST_DDL_TIME,TIMESTAMP
FROM all_objects
WHERE 1=1
AND owner IN ('APPS', 'XX')
AND TRUNC (LAST_DDL_TIME) = TRUNC (SYSDATE-5)
AND object_name LIKE '%XX%';
Comments
Post a Comment