set pages 50;
set lines 150;
set newpage 0;
set echo off;
set verify off;
set  define OFF
break on owner skip 1 on REPORT
TTITLE CENTER "SCHEMA's & OBJECTS SIZE REPORT" skip 1 CENTER "==============================" skip 2
select owner,segment_type , sum(bytes)/1024/1024 "size in MB" 
from dba_segments 
group by owner,segment_type
order by owner
/
TTITLE CENTER "SCHEMA's SIZE REPORT" skip 1 CENTER "===============" skip 2
select owner,sum(bytes)/1024/1024 "Size in MB" 
from dba_segments 
group by owner
/
---------------------------output ------------------------
                                                  SCHEMA's & OBJECTS SIZE REPORT                                                            
                                                  ==============================                                                            
                                                                                                                                                      
OWNER                          SEGMENT_TYPE      size in MB                                                                                           
============================== ================= ==========                                                                                           
COSMOS                         INDEX             9199.49219                                                                                           
                               TABLE             8139.33594                                                                                           
                                                                                                                                                      
DWEB                           INDEX                   1.25                                                                                           
                               TABLE                     35                                                                                           
                                                                                                                                                      
EDS                            INDEX             1867.03125                                                                                           
                               TABLE             1971.03125                                                                                           
                                                                                                                                                      
SYS                            CACHE               .0078125                                                                                           
                               CLUSTER             1.484375                                                                                           
                               INDEX                8.03125                                                                                           
                               ROLLBACK          366.289063                                                                                           
                               TABLE             19.7578125                                                                                           
                               TEMPORARY           30.46875                                                                                           
                                                                                                                                                      
SYSTEM                         INDEX                 .46875                                                                                           
                               TABLE                .421875                                                                                           


                                                      SCHEMA's SIZE REPORT                                                                 
                                                         ===============                                                                   
                                                                                                                                                      
OWNER                          Size in MB                                                                                                             
============================== ==========                                                                                                             
COSMOS                         17338.8281                                                                                                             
                                                                                                                                                      
DWEB                                36.25                                                                                                             
                                                                                                                                                      
EDS                             3838.0625                                                                                                             
                                                                                                                                                      
SYS                            426.039063                                                                                                             
                                                                                                                                                      
SYSTEM                            .890625