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

Home -> Community -> Usenet -> c.d.o.server -> Re: Table sizing

Re: Table sizing

From: frank <fbortel_at_home.nl>
Date: Fri, 20 Oct 2000 19:10:19 GMT
Message-ID: <39F098DA.9EFE8AB5@home.nl>

I use avg_row_len * num_rows * (1+pct_free/100) and add 15% for overhead.
A block may be marked in use, but not filled to the max, allowed by pct_free.

sigdock_at_my-deja.com wrote:

> As usual a great suggestion, thanks Sybrand. Somebody else gave me
> another tip: analyze the schema and select table_name, (blocks *
> block_size) from dba_tables. That gives extreme precise numbers.
> For those who are interrested...
>
> BertJan Meinders
> Oracle DBA
> ASR-ICT
>
> In article <971976221.1628.2.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > select owner, segment_name, segment_type, extents, ceil
 (bytes/1048576) Mb,
> > tablespace_name
> > from dba_segments
> > order by 1, 2
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <sigdock_at_my-deja.com> wrote in message
 news:8smtiq$uih$1_at_nnrp1.deja.com...
> > > Hi all,
> > >
> > > to determine a good value for the initial extent I want to check the
> > > actual sizes of the tables in our current database. What
 tables/views
> > > do I have to query to get the sizes of the tables, if possible in
 kB/MB
> > >
> > > t.i.a.
> > >
> > > BertJan Meinders
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Fri Oct 20 2000 - 14:10:19 CDT

Original text of this message

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