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

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 Received on Thu Jan 26 2006 - 20:13:06 CST