Table size and Tablespace size and Overall Database Size
We have made one generalize standard for tablespaces size for each and every production database initially...
so every database got same tablespace size intially and as when needed the datafiles extended by autoextend clause....
But from few years we are facing problem that at some sites in production database datafiles of tablespaces got full and we have to add new datafile into those tablespaces to accomodate data..
But i want to make standard tablespace size which can accomodate data of some duration.
So is there any documents or note that how can we calculate standard tablespace size (according to the application usages)? Individual table's actual occupied size and ratio of increment of table size?