Re: Table Sizing

From: Jen Decker <jen_at_sunflower.com>
Date: Thu, 21 Jun 2001 22:51:39 -0500
Message-ID: <B7582AFB.2C5E%jen@sunflower.com>

Very true. I had missed the statement about wanting the tables and indexes to be accurately sized.
My suggestion was definitely not accurate. Hopefully the original poster will read your post and the other one I saw with additional suggestions.
Jen

Nick P wrote:

> That is OK, but it is not quite that simple since it depends on the block
> size and percentage free space you are leaving...
>
> Recommended book:-
>
> Oracle Performance Tuning, 2nd Edition
> Published by O'Reilly
>
> By Mark Gurry & Peter Corrigan
> 2nd Edition, 1-56592-237-9, Order Number: 2379
>
> Is definitely a good book for sizing and tuning in general. It is worth
> every penny. When I worked for Oracle consultants would swear by this book.
>
> See the following link for an overview:-
>
> http://www.oreilly.com/catalog/oracle2/
>
> Nick
>
>
>
> "Jen Decker" <jen_at_sunflower.com> wrote in message
> news:B7575B86.2C27%jen_at_sunflower.com...
>> The simple solution is to multiply the row length by the number of rows. >> The same can be figured for the index, multiply the column(s) length by  the

>> number of rows.
>> Jen
>> 
>> 
>> 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(estimate)  without having to load sample data
>>> 
>>> Also if I have a unique index on column1, how do i size the index.
>>> 
>>> Many Thanks
>>> Mikey

Received on Thu Jun 21 2001 - 22:51:39 CDT