Re: PCTFREE and INITTRANS

From: Luke Davies <luked_at_cix.co.uk>
Date: 7 Jun 1998 21:27:36 GMT
Message-ID: <memo.19980607222221.12887A@luked.compulink.co.uk>

In article <6leat2$lmv$1_at_news.worldonline.nl>, vernes.j_at_consunet.nl (John Vernes) wrote:

>
> Luke Davies heeft geschreven in bericht ...
> >How big is the block size ( 8K as in BLOCK SIZE QUESTION? ) and how big
> >are the rows? I.e. Would you get many more rows in that extra 8%?
>
>
> Rowsize = 60
> 8% gives me +/- ((8192/100)* 8) / 60 = 10 extra rows per block
>
>
>

Sounds like a good candidate then for reducing the pctfree provided there is very little change in a rows size due to updating.

Luke Received on Sun Jun 07 1998 - 16:27:36 CDT