Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table sizing Q
Personally I wouldn't worry about the exact size, but instead determine if
they're small, medium or large and use Uniform Extent Sizes:
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
-----Original Message-----
From: Jack van Zanen [mailto:nlzanen1_at_ey.nl]
Sent: Friday, July 07, 2000 5:02 AM
To: Multiple recipients of list ORACLE-L
Subject: Table sizing Q
Hi All,
I've done an analyze on our test environment of all tables and want to size
my
tables for production properly.
(Our developers do not provide the sizing specs.)
My question is :
I have the average row length
I have the estimated nummer of records per year
I have the nummer of blocks for a certain record set.
What more block/row overhead should I be adding to calculate the tablesize
TIA Jack
-- Author: Jack van Zanen INET: nlzanen1_at_ey.nl 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 Fri Jul 07 2000 - 09:43:02 CDT