Re: datablocks

Do you mean 2048 rather than 2096

            and 4096 rather than 4192

The normal series of 'magic' numbers is 512,1024,2048,4096,8192 etc

If so I might either go for 2048 (2K) or maybe 4096 based on what you have said. Consider the amount of possible full table scans in conjunction with the avg and maximum row sizes. The aim being to pack as many rows into a block for sequencial access as possible. However balance this with the larger blocks coming back for random of index driven access.

Also you need to take a choice that will tend to avoid chaining and migration. i.e. rows that span more than one block. If your database contained longs, raws longraw, and clobs etc. you would want a lager block size although even then you might no avoid the problem just minimise it.

All a matter of a balancing act really.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Mars Labierint <mars_at_writeme.com> wrote in message news:384399b4.162411134_at_news.tip.nl...
> L.S.
>
> i want to create a database on a winnt machine
>
>
> I can format the harddisk in blocks of 512,1024,2096,4192 etc
> In the init.ora i can set the value for if.
> The export file is about 1 GB
> The database only contains small tekst and number fields
> The database will only grow, nothing gets deleted.
>
> What blocksize is the best for performance of the database?
>
> thanks,
>
> marcel van zanten
> mars_at_writeme.com
>
Received on Tue Nov 30 1999 - 06:24:53 CST