I took the following columns, table_name, tablespace_name, num_rows, avg_row_len from the user_tables, after I executed the analyze table command...

Followed, I'm calculating the Initial, next, pctincrease values based on the above, num_rows and avg_row_len colums.

Already, I calculated the Initial values, based on the following method,
Initial value (in bytes)= (num_rows * avg_row_len) / (2 ^ 20)

Samething, I want to calculate the other column values, next and pctincrease...

....



[QUOTE][i]Originally posted by sreddy [/i]
[B]I am not clear with what you wanted, I guess this z what you wanted... try running this and see the results are what you wanted...


rem -------------------------------------------------------------
rem Tablespace Usage
rem -------------------------------------------------------------

set pagesize 66
set line 132

clear breaks
clear computes

column "Total Bytes" format 9,999,999,999
column "SQL Blocks" format 999,999,999
column "VMS Blocks" format 999,999,999
column "Bytes Free" format 9,999,999,999
column "Bytes Used" format 9,999,999,999
column "% Free" format 9999.999
column "% Used" format 9999.999
break on report
compute sum of "Total Bytes" on report
compute sum of "SQL Blocks" on report
compute sum of "VMS Blocks" on report
compute sum of "Bytes Free" on report
compute sum of "Bytes Used" on report
compute avg of "% Free" on report
compute avg of "% Used" on report

select substr(fs.FILE_ID,1,3) "ID#",
fs.tablespace_name,
df.bytes "Total Bytes",
df.blocks "SQL Blocks",
df.bytes/512 "VMS Blocks",
sum(fs.bytes) "Bytes Free",
(100*((sum(fs.bytes))/df.bytes)) "% Free",
df.bytes-sum(fs.bytes) "Bytes Used",
(100*((df.bytes-sum(fs.bytes))/df.bytes)) "% Used"
from sys.dba_data_files df, sys.dba_free_space fs
where df.file_id(+) = fs.file_id
group by fs.FILE_ID, fs.tablespace_name, df.bytes, df.blocks
order by fs.tablespace_name;

[/B][/QUOTE]