database (Oracle9i on Red Hat 7.1) to house the wealth
of gene-expression data that has been generated in our
labs. Due to the nature of genetic information and the
volume of data that needs to be stored for each
experiment, certain tables will become extremely
large. After doing sizing estimates, several tables
will grow to approximately 75GB in three years. I am
aware of the fact that I will need to make use of
table partitioning and RAID.
But in the beginning (and to optimize performance), how
exactly should I plan for such tables. More
specifically and assuming a 75GB table - how large
should the tablespace sizes be?, number of datafiles
per tablespace?, number of extents per table? size of
extents?, etc.
Any help is greatly appreciated.