Re: PCTFREE and INITTRANS

From: Oracle DBA <robin.b.franklin_at_boeing.com>
Date: Mon, 8 Jun 1998 16:28:07 GMT
Message-ID: <Eu8r2q.sy@news.boeing.com>

Your INITRANS para. is too low for such a large size table! Even with a small table size but with a large number of users simultaneously access the table, the

later users will have to wait to access any necessary data blocks that were set aside by the number of INITRANS. Try the highest INITRANS and reducing it if performance and/or space is at a premium in the database.

Good luck,

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)
>
> 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
Received on Mon Jun 08 1998 - 11:28:07 CDT