How to obtain schema size and number of objects Posted by Roger Jerdez on September 28, 2015 Get link Facebook X Pinterest Email Other Apps 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
Comments