-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|