Re: Sizing Tables
From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Thu, 21 Jun 2001 10:30:51 -0700
Message-ID: <3B322F4B.B851F7FE_at_attws.com>
Date: Thu, 21 Jun 2001 10:30:51 -0700
Message-ID: <3B322F4B.B851F7FE_at_attws.com>
Larawole wrote:
> I have read numerous books but I still have not found a book that describes how
> to accurately size a table
>
> If I have a table
> create table tableA
> (column1 varchar2(20),
> column2 char(5),
> column3 number(5,2),
> column4 number(4));
>
> And I expect to have around 1000 rows in tableA. How do I calculate the
> storage parameters.
>
> Also if I have a unique index on column1, how do i size the index.
>
> Many Thanks
> Mikey
Go to dba_segments and add up the blocks used by the table or index (the segment_name field).
Daniel A. Morgan Received on Thu Jun 21 2001 - 19:30:51 CEST