database - Predicting Oracle Table Growth -


How can I predict the future size / development of the oracle tables?

Assume:

  • Linear increase in the number of rows
  • Known columns of basic data (four, number and date)
    • Ignore the variability of varchar2
      • <
    • The basic understanding of, and

    I see "Now measures, wait, measure again Something more active than ".

    1. Measure the average line size based on your data types.
    2. Estimate the available space in a block. This block size will decrease the block header size, from zero to space PCTFREE is avoided. For example, if your block header size is 100 bytes, then your PCTER is 10, and your block size is 8192 bytes, then the free space in a given block is (8192 - 100) * 0.9 = 7282 .
    3. Estimate how many rows will fit in that place, if your average line size is 1 KB, approximately 7 rows will be fitted in an 8 kb block.
    4. Estimate your rate rate, in units per line. For example, if you anticipate one million rows per year, then your desk will grow approximately 1 GB per year, 7 rows per 8 kB blocks

    Comments

    Post a Comment