From: krichine@my-deja.com
Subject: Re: How big or full is a table?
Date: 2000/05/05
Message-ID: <8evequ$rlh$1@nnrp1.deja.com>#1/1
References: <8esl9a$o1i$1@nnrp1.deja.com> <8eul6k$tim$1@nnrp1.deja.com> <957538241.3583.0.nnrp-12.c30bdde2@news.demon.co.uk>
X-Http-Proxy: 1.0 x30.deja.com:80 (Squid/1.1.22) for client 209.91.109.234
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Fri May 05 21:35:28 2000 GMT
X-MyDeja-Info: XMYDJUIDkrichine
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
X-Http-User-Agent: Mozilla/3.0 (compatible; StarOffice/5.1; Win32)



> > > But how can we tell just how full a table is?
> > > If it can expand to a maximum of 100 extents,
> > > how can we tell how many extents that the data
> > > is currently taking up?  Say, at 90 extents.

All of the advice and your script will tell you how much space has been
allocated for the table, it will not tell you how much of that space has
been actually used by data.

The difference may be as small as zero, if you never delete from a table
and if all of your allocated space is used, or as large as all allocated
space.

In other words, when you delete data allocated space is not deallocated.

Kirill Richine


Sent via Deja.com http://www.deja.com/
Before you buy.