First, I am dba beginner.
I have to create database.Databse will contain 2 tables.
First table with average row size = 159 bytes, and second table with average row size = 86 bytes.
Every day first table will be loaded with approximate 80 000 new rows per hour, and second with approximate 10 new rows per hour.
Tables will be Index-organized tables.Is it good or bad idea?
HD where will be database is with size allocation unit (cluster size on win2000) = 64k.
Which db_block_size I have to use?
Is there any way (mathematical) to calculate it?
Which increment value for datafile extend I have to use?
Which size of extents for my tables I have to use?
How to calculate others storage parameters?