Re: Find out the top 20 biggest tables

From: AndrewW <andyjgw_at_gmail.com>
Date: 18 Mar 2005 03:29:44 -0800
Message-ID: <1111145384.300505.94080@z14g2000cwz.googlegroups.com>

Nearly.

Exchange user_segments for dba_segments. user_segments only shows those top 20 tables owned by the user, not for the whole database.

Obviously, querying dba_segments requires appropriate privileges.

Rgds
AW

kirtan wrote:
> Ralf Bender wrote:
> > Hi
> >
> > has anyone a script to find out the top 20 biggest tables in a
> tablespace?
> >
> > regards
> > ralf
>
> select * from (
> select segment_name from user_segments where segment_type='TABLE' and
> tablespace_name='<tablespacename>' order by bytes desc
> ) where rownum <=20
Received on Fri Mar 18 2005 - 05:29:44 CST