Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Table sizing Q
There are basically three other items you need:
After you have these, then it's a matter of:
rows_per_block = block_size - ((block_size * pctfree) + (8 * maxtrans))/avg_row_length (sorry about the wrap)
After that:
table_size = ((#_of_rows_per_unit_time/rows_per_block) * block_size) +fudge_factor
In my case "fudge_factor" really comes from the area of the anatomy firmly in contact with chair cushion.
Dick Goulet
____________________Reply Separator____________________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 mayReceived on Fri Jul 07 2000 - 08:09:48 CDT