9 lines
241 B
SQL
9 lines
241 B
SQL
SELECT tablespace_name, sum ( blocks ) as free_blk ,
|
|
trunc ( sum ( bytes ) / (1024*1024) ) as free_m ,
|
|
max ( bytes ) / (1024) as big_chunk_k,
|
|
count (*) as num_chunks
|
|
FROM dba_free_space
|
|
GROUP BY tablespace_name
|
|
/
|
|
|