Re: SIZE of table

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Fri, 19 Jan 2001 07:43:00 -0400
Message-Id: <10746.127120@fatcity.com>

On Fri, 19 Jan 2001, you wrote:
> Hi all,
> Is there any way to know the size of table in a
> database.
> If my table is having 25 columns and 100000 rows
> By querying any table can I know size of this table

There's a couple of quick and dirty ways to do it - select bytes from dba_segments where segment_name = 'TABLE_NAME', or analyze the table and take the avg_row_len and multiply is by the number of rows.

Both of these give a good estimate of the size of the tables. I believe dbms_space can give a more accurate picture, but I haven't yet had to go beyond what dba_segments will give. Received on Fri Jan 19 2001 - 05:43:00 CST