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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
