Re: Estimate production table size

As such there are no rules for this but you can do this in two ways.

1. By considering the exact size of the fields and the estimated number of rows.
2. By considering the average row size (can be calculated using analyze table command) and the estimated number of rows.

This what I think is used in capacity planning pracice.

Vijay

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3EC09BE9.3FF0_at_yahoo.com>...
> Jack wrote:
> >
> > I was asked in an interview by the following
> > Given a table in development, how do you estimate the table size in
> > production.
> >
> > Can someone give any guideline or point me the places where I should be
> > looking at? Thanks.
> >
> > - Jack
>
> analyze table XXX compute statistics
>
> USER_TABLES gives you average row length and blocks used, and its pretty
> easy to extrapolate from there
Received on Tue May 13 2003 - 12:06:01 CDT