Database Table Size?

[amerbaig]

I have to create a table which will contain 39 columns and 85000000. How I should set storage parameters of table. I mean block size, extents etc Please guide me. I need best performance.

Regards
Amer

 

[Guest_imported]

For starters, try this approach:

1) Get an estimate of the number of records for the table, both now, and for a projected to 6 month period 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) To determine database's block size:
select value from v$parameter where name = 'db_block_size';

Now you should have all of the information needed to size your 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.

Hope this helps!

 

[amerbaig]

Excellent help!

Thanks