Re: Calculate the BIGGEST table(in space) in one tablespace efficiently?

"dominica_at_gmail.com" <dominica_at_gmail.com> wrote in news:1138327986.648097.84450_at_g14g2000cwa.googlegroups.com:

> Hi Everyone,
>
> I am running oracle 8.1.7.4 (32 bits) on solaris 5.9 platform.
>
> I have a 115 GIG tablespace (ABC), and
> I would like to find out the biggest table in this tablespace.
>
> I am not counting the number of rows(records).
> I know I could do "select count(*) from each_table".
> The reason why the max # of rows table does not mean the
> biggest space consumer, is as follows:-
>
> Some of my table has 1000 columns(don't ask me why there is so many
> columns,
> I did not design those tables) and some table might have only 3
> columns.
>
> I want to make a list to see the top 10 BIGGEST TABLES( the one
> consume the
> most space in this tablespace).
>
> I know I might able to do something with dba_segments table,
> but what is the most efficiently way to find out.
>
>
> Thank in advance,
>
>
>
> Dominica
>
>

First make it work, then make it efficient! Received on Thu Jan 26 2006 - 20:50:59 CST