Re: freelist_group_id

setting a freelist groups > 1 will also help to reduce contention on tables that have a real large number of inserts. (basically if processes > max freelists, add more freelist groups ...)

K.J.K.

Heggelund wrote:

> --
>
> If you have not specified freelist groups in the create table statements, this
> parameter would always be 1. You default only have one freelist group
> and one freelist for each table.
>
> Only if tables are very heavy inserted into would you change the freelist
> parameter to avoid contention on the freelist. The freelis group
> parameter are sometimes used in a parallell server environment, assigning one
> freelist group to each node to avoid pinging between nodes.
>
> Rgds
> Steinar Heggelund
>
> ----------------------------------------------------------------------------
> I'm employed in the Norwegian consulting company Opus One AS.
> I have 7 years experience with the Oracle database, mainly on Unix.
> My postings represent my opinions and they may be wrong.
Received on Sat Dec 06 1997 - 00:00:00 CST