How to obtain schema size and number of objects



SELECT owner, count (distinct segment_name) as obj_number, sum(bytes) / 1024/1024/1024 as "Gigas"
FROM dba_segments
WHERE owner in  ('SAPSR3')
GROUP BY owner;

Comments