RE: Tuning question: FREELIST GROUPS

Hi Raj,

Thanks, now I know than multiple groups of instance can reduce freelists = contention for multiple instances accessing same table.

regards,

Sinardy

=20

-----Original Message-----
From: Raj Kumar [mailto:raj.anuradha_at_gmail.com] Sent: 30 September 2004 18:03
To: Sinardy Xing
Cc: oracle-l_at_freelists.org
Subject: Re: Tuning question: FREELIST GROUPS

Dear Sinardy,

Freelist Groups is for Oracle Parallel Server or RAC.

It reduces contention on the segment header block, and reduce=20 inter-instance "pinging", at the cost of excessive disk space consumption.

Please refere Oracle Concepts guide for more details.

Thanks and regards
Raj

On Thu, 30 Sep 2004 17:29:13 +0800, Sinardy Xing <sinardyxing_at_bkgcomsvc.com> wrote:
> Hi all,
>=20
> Why we need FREELIST GROUPS?
>=20
> What are the differents (in terms of advantages) between
>=20
> CREATE TABLE mytable STORAGE (FREELISTS 2);
>=20
> and
>=20
> CREATE TABLE mytable STORAGE (FREELISTS 4 FREELIST GROUPS 2);
>=20
> regards
> Sinardy
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l