-
database planning
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?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|