Re: How to calculate free space left in tablespace

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Aug 1999 03:45:02 GMT
Message-ID: <37d0ce1a.52938842@netnews.worldnet.att.net>

On Wed, 18 Aug 1999 22:09:23 GMT, "Seigmund Akinwande Johnson" <asjohns_at_midway.uchicago.edu> wrote:

>I would like to know how to calculate the amount of space left in a
>tablespace ?
>using dba_free_space does not help because I have added data into the tables
>in that tablespace
>but still the values are the same.

The reason that dba_free_space does not change is that space is allocated to tables in large chunks called extents. You won't see the results of adding rows to your table until you fill one extent and cause another to be allocated.

You can use the ANALYZE TABLE command to have Oracle count up the bytes used by a particular table if that helps.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Thu Aug 19 1999 - 22:45:02 CDT