Re: table size

From: Ushkalo Igor <igorus_at_protek.ru>
Date: 2000/07/14
Message-ID: <396F14A9.B7AC9740@protek.ru>#1/1

corrado brambilla wrote:
>
> Hi, I need to calculate a table size for any tables in my db.
> Please advice how to do so.
>
> Thanks
> Corrado.

Try this. But such query can return a lot of rows - restrict it by where clause.

select SEGMENT_NAME

     , sum(BYTES) BYTES
     , trunc(sum(BYTES)/(1024*1024)) MBYTES
     , sum(BLOCKS) BLOCKS

from DBA_SEGMENTS
where SEGMENT_NAME like '<your tablename>%' group by SEGMENT_NAME

• Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198

Received on Fri Jul 14 2000 - 00:00:00 CDT