Re: table size
From: Ushkalo Igor <igorus_at_protek.ru>
Date: 2000/07/14
Message-ID: <396F14A9.B7AC9740_at_protek.ru>#1/1
from DBA_SEGMENTS
where SEGMENT_NAME like '<your tablename>%' group by SEGMENT_NAME
Date: 2000/07/14
Message-ID: <396F14A9.B7AC9740_at_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