-
I have a oracle Database running in the NT box, I have allocated
nearly about 3G for my application tablespace which is in perl and uses stored proce
dures, function, tables, indexes and temporary tables.
I estimated all the block segements of all tables and indexes and it is right now
occupying about 700 MB of block segments.
I need to estimate roughly how much space will be required for the data in the
database and that I have to recommend.
Before doing any calculation, I like to get some feedbacks on that.
My questions here, If i get 100 times of the presents data in the database,
what will be the size of blocks for the indexes. Is it gonna be 100 times of present
or any other things i need to consider for that estimation?
I got confused with the present block segement usage by few index files. Some are using 1/2 times of its original table, some are taking as same and some are taking 2 times.
What Other factors that I need to consider to estimate the future space requirements?
Any thoughts and information?
Thanks
SKM
-
sizing
hi,
u have not indicated to the version of the oracle server u are using, as u would be knowing oracle 7.x works very well with segments having a very few extents, whereas from oracle 8.x onwards, u do not have this issue, regds. to sizing uer segments i would say that u need the classical approach of sizing uer extents as multiples of block sizes and and the extents what u would be allocating to uer segments also would need to be studied, whatever data which would have entered into the database should give u a reasonable picture of the growth of tables, u need to find out the avg. length of each row, and then contiue with a discussion with the end users to understand howmuch data loading they would be doing, with this background u could size uer tables, always go in for a higher figure than what u have estimated better to err on the higher side than to get stuck later,also remember that data inserts and updates affect the indexes in a varied ways, this would mean that u need to do a through analysis of uer index segments, for this kind of work there is only a study and more study and continous monitoring of the segments usage that should be able to help size uer indexes, index sizing also is very well documented by oracle look up into the documentation, if i were u i would check out the database activity continously to understand how the indexes are being affected.
bye
soren
