Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Find out the top 20 biggest tables
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 - 04:07:49 CST