Re: System tablespace growing

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 30 Apr 2003 20:58:48 +1000
Message-ID: <QNNra.25516$1s1.388438@newsfeeds.bigpond.com>

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:blrra.10890$pK2.14154_at_news.indigo.ie...
> what's wrong with just
>
>
> select * from (select owner,segment_name,bytes/1024/1024 MB from
> dba_segments where TABLESPACE_NAME = 'SYSTEM' ) where rownum < 11 order by
> MB desc;
>
> This gives you the top 10 space hoggers in SYSTEM
>

Hi Telmachus,

Actually it doesn't.

It gives you the first ten selected segments, ordered by size which is not the same thing.

To list the top ten largest segments, rewrite as follows:

select * from (select owner,segment_name,bytes/1024/1024 MB

                     from dba_segments
                     where TABLESPACE_NAME = 'SYSTEM'
                     order by MB desc)

where rownum < 11;

Cheers

Richard Received on Wed Apr 30 2003 - 05:58:48 CDT