|
|
|
Table Fragmentation
| column |
tablespace_name |
format |
a15 |
heading |
"Tablespace" |
| column |
"size_mb" |
format |
999,999.99 |
heading |
"Size, MB" |
| select |
FE.tablespace_name,
Round(Sum(bytes)/1024/1024, 2) AS "size_mb" |
| from |
dba_free_space FE,
(SELECT S.tablespace_name, Max(S.next_extent) AS
"min_next_extent" |
| from |
dba_segments S |
|
|
| where |
S.segment_type = 'TABLE' |
|
|
| and |
S.tablespace_name <> 'SYSTEM' |
|
|
| group by |
S.tablespace_name) MS |
|
|
| where |
FE.tablespace_name = MS.tablespace_name |
|
|
| and |
FE.bytes < 10*MS."min_next_extent" |
|
|
| group by |
FE.tablespace_name; |
|
|
|
