Re: Table sizing

From: <sigdock_at_my-deja.com>
Date: Fri, 20 Oct 2000 10:55:35 GMT
Message-ID: <8sp8b6$rf9$1@nnrp1.deja.com>

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 - 05:55:35 CDT