Re: Estimating storage

From: news.insysnc.net <suresh.bhat_at_mitchell-energy.com>
Date: 1998/03/06
Message-ID: <01bd495d$0ac34f00$a504fa80@mndnet>#1/1

Otto <oradke_at_efn.org> wrote in article <34fb96bb.5752191_at_news.efn.org>... wrote
> I am looking for information regarding how much storage space an
> Oracle database will take up based on the various data types.
>
> Thanks,
>
> Otto
>

If it is an already populated table, in Oracle 7.3.3, try using

select sum(vsize(col1)) + sum(vsize(col2)) + ....... sum(vsize(colN))

from table_name;

This will give you the actual size in bytes of Oracle internal representation of all the data records in that table. In other words the size of the table.

Suresh Bhat Received on Fri Mar 06 1998 - 00:00:00 CST