Tuesday, 12 May 2015

How to check month wise object creations with size and owner

set lines 300
set pages 300
select do.owner,do.object_name,do.object_type,ds.BYTES,created from
dba_objects do, dba_segments ds
where do.object_name=ds.segment_name
and to_char(created,'MON-YY')in ('JAN-15')
order by 5
/

No comments:

Post a Comment