Oracle-L: How to calculate table size in 8i

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Tue, 09 Jul 2002 19:53:19 -0800
Message-ID: <F001.00493323.20020709195319@fatcity.com>

Hi Gurus,

I found an article in metalink 105765.1 "How to Determine Approximate Hard Drive Space Needed for a Specific Table". The formula for disk space is simply multiplying the average row length (by analyzing the table) * the number of rows in the table. It's very different from Metalink 10640.1 "Extent and Block Space Calculation and Usage in V7 Database" where it takes the block header etc in considerations but of course, article 10640.1 is for Version 7.

How do you gurus calculate table space in Version 8 ? Please advise. Thanks.

Regds,
New Bee

Doc ID </help/usaeng/Search/search.html> : 	Note:105765.1	Content
Type: 	TEXT/PLAIN	
Specific Table	Creation Date: 	18-APR-2000	
Type: 	PROBLEM	Last Revision Date: 	26-DEC-2000	
Status: 	PUBLISHED

Problem Description

How can you determine how much disk space is needed for a table?

Solution Description

You can use SQL to determine how much space is needed for the table based upon the average row length.

compute statistics about this table:

analyze CEUSER.CE_STATEMENT_LINES
compute statistics;

Now determine the average row length in bytes:

   select avg_row_len
   from dba_tables
   where table_name=' CE_STATEMENT_LINES';

AVG_ROW_LEN

2. Multiple the average row length in bytes by the number of rows you believe

you will need:

98 (bytes) x 10000 records = 980000 bytes needed

References

For more information on the ANALYSE command, you may wish to refer to:

Oracle8 SQL Reference Release 8.0, Part No.A58225-01

Also:

Oracle8i SQL Reference Release 8.1.5, Part Number: A67779-01 .
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: CHAN Chor Ling Catherine (CSC)
INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 09 2002 - 22:53:19 CDT