SQL> set pagesize 10000
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;
SEGMENT_TYPE Size of Each Segment in MB
------------------ --------------------------
CLUSTER 1872.0625
INDEX 1419.3125
INDEX PARTITION 166.25
LOB PARTITION .1875
LOBINDEX 17.1875
LOBSEGMENT 478.8125
NESTED TABLE 1
ROLLBACK 2
TABLE 1218.875
TABLE PARTITION 441.3125
TYPE2 UNDO 1055.5625
--------------------------
TOTAL 6672.5625
11 rows selected.
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;
SEGMENT_TYPE Size of Each Segment in MB
------------------ --------------------------
CLUSTER 1872.0625
INDEX 1419.3125
INDEX PARTITION 166.25
LOB PARTITION .1875
LOBINDEX 17.1875
LOBSEGMENT 478.8125
NESTED TABLE 1
ROLLBACK 2
TABLE 1218.875
TABLE PARTITION 441.3125
TYPE2 UNDO 1055.5625
--------------------------
TOTAL 6672.5625
11 rows selected.
No comments:
Post a Comment