Slightly more accurate to add 1 per column
to allow for the length byte, then 5 per row
to allow for the row overhead.
--
Jonathan Lewis
Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html
Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html
Dhananjay Sen wrote in message
<2e5b0db8.0106271230.529eaf85_at_posting.google.com>...
>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 - 17:21:21 CDT
