SQL> set autotrace on statistics SQL> set timing on SQL> select object_name, object_type 2 from all_my_objects o 3 where last_ddl_time = ( select max(last_ddl_time) from all_my_objects o2 where o2.owner = o.owner); OBJECT_NAME OBJECT_TYPE ------------------------------ ------------------- 528 rows selected. Elapsed: 00:00:23.20 Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 22040 consistent gets 12050 physical reads 0 redo size 17172 bytes sent via SQL*Net to client 805 bytes received via SQL*Net from client 37 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 528 rows processed