Re: Table Sizing

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 - 13:48:03 CDT