size Estimates -Michael R Ault

From: YI QUN ZHOU <yzhou1_at_osf1.gmu.edu>
Date: 22 Mar 1995 02:42:33 GMT
Message-ID: <3ko2qp$t2_at_portal.gmu.edu>


One of my friend has the following problem in estimating the oracle table size:

I am trying to understand the size estimation as given in the book "Oracle 7.0 Administration and Management" by Michael R Ault. I am referring to Page 79 ; 3rd item --Calculate the ADL I need some help in understanding what the author meant by

  1. fixed records vs. variable length records
  2. ave_prec
  3. How does the formula correlate to various types of oracle data types.

If somebody has got enough patience, an example work-out will be appreciated.
Thanks. Received on Wed Mar 22 1995 - 03:42:33 CET

Original text of this message