FINDING SCHEMA SIZE FOR A ORACLE DATABASE

SQL> BREAK ON REPORT SQL> COMPUTE SUM LABEL TOTAL OF “Size of Each Segment in MB” ON REPORT SQL> select segment_type, sum(bytes/1024/1024) “Size of Each Segment in MB” from dba_segments where owner=’SYS’ group by segment_type order by 1;  

Read More