Re: size in bytes of a table

From: Dave <x_at_x.com>
Date: Mon, 18 Jul 2005 17:59:58 GMT
Message-ID: <y6SCe.72486$G8.46657@text.news.blueyonder.co.uk>

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1121694951.954023.134620_at_g14g2000cwa.googlegroups.com...
> The user_segments view will give you the allocated size of the table or
> index segment. Since a heap table and normal index can share the same
> name you might also want to include " and segment_type = 'TABLE' ".
> This points out that you may also want to count up the size of the
> indexes associated with the table. You can find all the indexes for a
> table by looking at all_, user_, or dba_indexes.
>
> You can find all the dictionary views documented in the Oracle version#
> Reference Manual.
>
> If you want to know the used as opposed to allocated space then
> multiply dba_tables.blocks times the tablespace block size.
>
> HTH -- Mark D Powell --
>

nice spot Received on Mon Jul 18 2005 - 12:59:58 CDT