How to find the information about free space of each table

[ligang]

I want to know how much free space in the table segment and there are distribution . Is it possible ?

[grjohnson]

Analyze you tables and then

select table_name, empty_blocks from user_tables;

It'll return the table's name and free blocks. You can calculate free space via empty_blocks * block_size.

Cheers

[ligang]

It's a good idea , It's even better if you can provide the way to have the free chunk (distribution in the extend)

[pando]

use dbms_space