How can I predict the future size / growth of an Oracle table?
Assuming that:
- linear increase in the number of rows
- known columns of basic data types (char, number, and date)
- ignore vararch2 variability
- basic understanding of the space required to store them (e.g. number )
- basic understanding of blocks, extents, segments and block overhead
I am looking for something more active than "measure now, wait, measure again."
source
share