|
|
|
Tablespace Usage Report
| column |
Tablespace |
format |
A25 |
heading |
'Tablespace' |
| column |
Allocated |
format |
99,999 |
heading |
'Size|(MB)' |
| column |
div1 |
format |
A3 |
heading |
' | ' |
| column |
Used |
format |
99,999 |
heading |
'Used|(MB)' |
| column |
Unused |
format |
99,999 |
heading |
'Unused|(MB)' |
| column |
Pct_Used |
format |
999.99 |
heading |
'Used|(%)' |
| column |
div2 |
format |
A3 |
heading |
' | ' |
| column |
TotalFree |
format |
9,999 |
heading |
'Free|(MB)' |
| column |
Pct_Free |
format |
999.99 |
heading |
'Free|(%)' |
| column |
MaxFree |
format |
9,999 |
heading |
'MaxFree' |
| select |
x.tablespace_name |
|
|
|
Tablespace, |
| |
x.bytes/(1024*1024) |
|
|
|
Allocated, |
| |
(x.bytes-sum(y.bytes))/(1024*1024) |
|
|
Used, |
| |
x.bytes/(1024*1024) - (x.bytes-sum(y.bytes))/(1024*1024) |
Unused, |
| |
((x.bytes-sum(y.bytes))/ x.bytes)*100
|
|
Pct_Used, |
| |
sum(y.bytes)/(1024*1024) |
|
TotalFree, |
| |
(sum(y.bytes)/x.bytes)*100 |
|
Pct_Free, |
| |
max(y.bytes)/(1024*1024) |
|
MaxFree |
| from |
sys.dba_data_files x ,
sys.dba_free_space y |
|
|
| where |
x.file_id = y.file_id |
|
|
| group by |
x.tablespace_name,
x.bytes |
|
|
| order by |
1; |
|
|
|
