Re: Table sizing

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 19 Oct 2000 17:03:48 +0200
Message-ID: <971976221.1628.2.pluto.d4ee154e@news.demon.nl>

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.
Received on Thu Oct 19 2000 - 10:03:48 CDT