dba_objects_ddl_modification.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Find all objects in the database order by last modification of the object i.e. LAST_DDL_TIME.
-- Call Syntax  : @dba_objects_ddl_modification.sql
-- Last Modified: 20/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN owner FORMAT a30
COLUMN object_name FORMAT a30
SELECT owner,
       object_type,
       object_name,
       status,
       last_ddl_time
FROM dba_objects
ORDER BY
  last_ddl_time ASC,
  owner,
  object_name;