Volumetrics and sizing when creating database

Can anyone point me in the right direction for sizing blocks, and volumetrics etc when setting up a database?
NiksterAsked:
Who is Participating?
 
YodaMageCommented:
What database are you using where you are concerned with block size? Just for the record, Paradox is evil, lol.

Being serious though, for Paradox, all we ever did was determine record size * expected size of dataset, then changed the block size to reflect those size requirements with a margin of error torward to large a block size.

Either way, if you have a problem, you can change the block size of the data set to a larger size with a rebuild of the data structure, so it really wasn't critical.
0
 
NiksterAuthor Commented:
It is an Oracle database, and from what I understand you can't change the block size after creation.  Thank you, though....
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
NiksterAuthor Commented:
Thanks - that helps!
0
 
GreymanCommented:
The other thing to note (if you are putting specific tables on specific disks or something fancy like that) is the vital importance of understanding that your volume estimates will be wrong - give yourself contingency space and understand that the relative sizes of tables may change due to changes in the outside world.
0
 
YodaMageCommented:
What else do you need?
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: YodaMage  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.