Re: PCTFREE and INITTRANS

From: Luke Davies <luked_at_cix.co.uk>
Date: 6 Jun 1998 15:03:17 GMT
Message-ID: <memo.19980606155807.4101D@luked.compulink.co.uk>

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

> Our biggest tables (40 and 20 million records) and in our application
> are
> used very frequently for querrying. We have allready set thePCTFREE to
> 10
> and INITTRANS is still set to 1.
>
> Those tables are very high on queries and very low on updates/deletes
> and
> somethings large batches of inserts.
>
> What problems could I encounter when I would set the PCTFREE extremely
> low???
> For instance 2 percent (<= Muchos data in data block)

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%?

>
> Would it be advisable to set the INITTRANS higher than 1??
> I ask this, because of the huge amount of data (40M records) and the
> chanche
> of
> needing to have more transactions on the same block.
>
> Thanxs and Greetz
>
> John
>
>
>

Luke Received on Sat Jun 06 1998 - 10:03:17 CDT