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@xxxxxxxxx] Sent: 30 September 2004 18:03 To: Sinardy Xing Cc: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l