TOAD (Tool for Oracle Application Development) is a great tool that allows
point and click access to this kind of information. Not sure it can monitor
this, but you could easily navigate to a window listing segments in a
tablespace and then sort on number of extents or size.
--
"kielhd" <kielhd_at_freenet.de> wrote in message
news:10a4173d.0305182348.241523a9_at_posting.google.com...
> 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
Received on Mon May 19 2003 - 23:30:51 CDT
