I have learned that every data block allocated to a table may not be completely filled and is governed by the PCTFREE and PCTUSED parameters.
I am trying to write a unix script which will automatically determine tables which are candidate for TABLE reorg.
I can imagine a code which first determines which tables have block fragmentation and then list such tables as candidate for table reorg.
For this, I would need some parameter called 'Average freespace' in a table.
Can anyone tell me how to find out the Average Free Space in a table ?