Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Estimate Oracle Table Size
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 Received on Sat Jan 04 2003 - 11:14:52 CST
![]() |
![]() |