Re: INITIAL, NEXT, PCTFREE and PCTUSED

Hi

1. Initial: It is a good idea if you have few extents in table. So if you know how large is one row, and how will your datas growing, you can determine the first extent. It should be large enough . If you have more large table, set the largest block size (8K) when create the database. 2.Next: many people set it bigger then the initial. for table maybe good. if you set bigger also can use PCTINCREASE parameter to determine the percentage of the next extent. 3.PCTFREE: this parameter determine the free space to later time upgrade inside the block. When you determine the block size, take care the row length. If you choose a wrong size, you will have a lot of chained or migrated rows, and not too good performance. If you have a lot of upgrade set it higher, but generally it's better to have a small pctfree and some migrated rows, than high pctfree and only a few rows per block. default is 10 4.PCTUSED:if you will many delete operation this table set it high else let it to default or if you have few delete on this table set it low.default is 40

do not forget analyze your tables!
I hope this will help

feherl
Jack Zhu wrote:

> For creating a table which will store large data and has millions rows, how to
> determine the proper size of INITIAL, NEXT, PCTFREE, and PCTUSED?
>
> Thanks!
Received on Tue Sep 07 1999 - 14:39:31 CDT