set pages 999 col "size MB" format 999,999,999 col "Objects" format 999,999,999 select obj.owner "Owner" , obj_cnt "Objects" , decode(seg_size, NULL, 0, seg_size) "size MB" from (select owner, count(*) obj_cnt from dba_objects group by owner) obj , (select owner, ceil(sum(bytes)/1024/1024) seg_size from dba_segments group by owner) seg where obj.owner = seg.owner(+) order by 3 desc ,2 desc, 1 /
This Blog is also nick named as Oracle Slate, where we can chalk our experiences with Oracle Databases and related products of Oracle. This blog is very simple to understand and relatively useful for all the budding Oracle Dba's, Beginner Dba's, Dba's Under-Construction and Experienced Dba's...
Sunday, July 10, 2011
Distribution of objects and data
Which schemas are taking up all of the space
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment