Re: Estimate Oracle Table Size

From: Paul Boothroyd <paul.boothroyd_at_ntlworld.com>
Date: Mon, 20 Jan 2003 18:54:04 +0000
Message-ID: <3E2C45CC.4000001@ntlworld.com>

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
>
Received on Mon Jan 20 2003 - 12:54:04 CST