Re: Tablespace is running out of space (Oracle8i Enterprise Edition Release 8.1.7.0.0)

kielhd wrote:
>
> Hi,
> I am looking into the following problem and hope to get some help
> here.
>
> One of the tablespaces I am using was nearly out of space. I enlarged
> it to keep the database running.
>
> Of course, there is a lot of traffic on the database and lots of
> sentences are inserted/updated every day into lots of tables. I know
> that the tablespace has to run out of space because of this someday! I
> just like to know the main reason for this.
>
> Is Oracle collecting data that can tell me which tables are increasing
> in size fast?
> Are there tools from Oracle available to monitor this?
>
> Thanks in advance
> Henning

start with dba_segments - it will tell you the break up of size for each segment within each tablespace

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"