Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Estimate Oracle Table Size

Re: Estimate Oracle Table Size

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 04 Jan 2003 09:14:52 -0800
Message-ID: <3E17168C.ACAE1499@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US