Hi All,

I have to get table and index spaceing reports everyday in the production environment. I wrote the script, displayed the following columns, tablename, tablespacename, blocks used, free blocks, avg.lenth. from the dba_tables/user_tables...

I calculated the Initial in MB, based on the num_rows and avg_row_len columns.

like, (num_rows * avg_row_len / 2^20)

Samething, I want to evaluate, next, pctincrease and so...

Please, update me asap, If anyone have the formula of the above...

Thanks

-Tami