Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table and schema current size.

Re: Table and schema current size.

From: Dhananjay Sen <dhananjay_sen_at_hotmail.com>
Date: 27 Jun 2001 13:30:26 -0700
Message-ID: <2e5b0db8.0106271230.529eaf85@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 - 15:30:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US