Re: table size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/27
Message-ID: <38DF6242.56EE@yahoo.com>#1/1

leokim_at_my-deja.com wrote:
>
> Hi,
>
> This is a new guy again. If someone could help me how to estimating
> new table size in ORACLE, I would greatly appreciate that. I know in
> sybase it uses sp_estspace but don't know in ORACLE.
>
> Thanks in advance
> Leo
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Server Admin guide contains a full formula, but if you're looking for a (very quick) hack:

size =
num_of_rows *
( 100 +

      sum of lengths of char columns +
      half sum of lengths of number columns +
      7 bytes per date column
    ) * 1.1    (assuming 10% pctfree)

In any event, you are typically looking for a 'rough' not exact guide, because you want your table sizes to be defined if equi-sized chunks anyway.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Mon Mar 27 2000 - 00:00:00 CST