Re: How to find the table size?

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 20 Jun 2001 06:50:58 -0700
Message-ID: <F001.0032FE07.20010620045649@fatcity.com>

To calculate the storage needed for a table (assuming that all rows will contain all of the data) use the following formula.

---

TO DETERMINE THE SIZE OF A TABLE STORAGE step 1. NUMBER OF ROWS IN TABLE. ---------------

step 2. NUMBER OF ROWS IN BLOCK.

NUMBER =COLUMN SIZE. 21 (maximum)
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7 Z=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF COLUMNS > 250)

X= DBBLK SIZE / Z       ---------------------------------------------

Y=DBBLK-(%FREE(DBBLK-(52+4(X)))

Y>=X*Z  ADJ X TO GET "TRUE"               ---------------------

step 3. TOTAL BLOCKS NEEDED.

TOT BLOCKS=ROWS IN TABLE/ROWS PER BLOCK TABLE SIZE =DBBLK SIZE * TOT BLOCKS / 1024 GIVES TABLE SIZE IN K.

---

I always calculate storage for 2 years of data. ROR mª¿ªm                                  

>>> sqlgreg_at_pacbell.net 06/19/01 03:50PM >>>
> I need to calculate the size of the table assuming one of the rows is
having
> all the columns maxsize possible.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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 Wed Jun 20 2001 - 08:50:58 CDT