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%';

Comments

Popular posts from this blog

Deleting the Sourcing Rule Assignments API

BarCode with XML Publisher