Re: Estimate Oracle Table Size

Paul Boothroyd wrote:

> ANALYZE TABLE cannot be used, as this is based upon the current content.
> The formulae are there to estimate the disk space requirements for a
> server into the future. This can be quite complicated with variable
> length records.
>
> Unfortunately I have minimal knowledge of Oracle specifics in this
> manner (currently learning DBA specifics).
>
> DA Morgan wrote:
> > Trupti wrote:
> >
> >
> >>Hi,
> >> I am trying to get table size estimate based on number of rows. In
> >>Oracle 8.0 DBA guide there was detailed formula/steps for schema
> >>objects space requirements. Can anyone tell me if there is one for
> >>Oracle 8i or 9.2. What article can I use as basis to calculate table
> >>size estimates.
> >>
> >>Thanks,
> >>TMR
> >
> >
> > Why guess? Depending on what you need ...
> >
> > Go to http://tahiti.oracle.com and look up ANALYZE TABLE.
> >
> > Or take a look at the information stored in ALL_SEGMENTS.
> >
> > Daniel Morgan
> >

Then go to http://tahiti.oracle.com and look up what you seek: It is there.

Daniel Morgan Received on Sat Jan 18 2003 - 13:49:38 CST