Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table and schema current size.
The approximate size of the row of a table can be calculated using the following query on the specified table in blocks :
select avg( nvl(vsize(column1) ,0) ) + avg ( nvl(vsize(column2) , 0)
) + ...........
from test_table
Multiply the result with the number of rows in the table to get total number of blocks occupied by the table data. Now covert blocks to bytes ( Multiply by DB_BLOCK_SIZE ) .
D.Sen Received on Wed Jun 27 2001 - 15:30:26 CDT