Re: Retrieving Oracle Table size in Bytes

From: Joachim Pense <joachim.pense_at_t-online.de>
Date: Wed, 31 Jan 2001 22:24:41 +0100
Message-ID: <959vqp$8l7$04$2@news.t-online.com>

newopt_at_my-deja.com> wrote
> > I looked in dba_tables for an oracle table size in bytes but didn't see
> > a column that reflects the size of the table in bytes.
> >
> > Where can this information be retrieved from?
> >
> > Thanks
> >

Mark Wagoner replied:

> You need to sum all the segment sizes for the table. Use dba_extents for
> the table/segment name. This will give you only the allocated space,
> since an extent is pre-allocated, not necessarily used.

It seems strange (and often annoying) that with Oracle dbs, you cannot really answer the question: "How much space do your data occupy?".

Will they do something about it in Oracle 9i? I doubt it.

Joachim Received on Wed Jan 31 2001 - 15:24:41 CST