1) Get an estimate of the number of records for the table, both now, and
projected to 6 months from now
2) Find the average length of each record. If you cannot do this
perfectly, then try to make a good guess.
3) Determine how often the table is updated/inserted/deleted. If it is
changed often (and the record sizes vary), then the PCTUSED would be
low, something like 40-60. If the table is static, then I'd make the
table PCTUSED 85 or 90.
4) Determine my database's block size:
select value from v$parameter where name = 'db_block_size';
Now I have all of the information needed to size my table:
Records per block = (block size - 110 bytes for overhead) * (PCTUSED/100)/
Average Record Size
Total blocks = (records in table) / (records per block)
Total table size = blocks * block size
Give a little fudge factor and make this your INITIAL extent size.
Your NEXT will be determined by your 6 month growth projection.Thursday, August 25, 2011
Table Sizing Information
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment