RE: Tuning question: FREELIST GROUPS

Hi all,

Why we need FREELIST GROUPS?

What are the differents (in terms of advantages) between

CREATE TABLE mytable (col CHAR(1)) STORAGE (FREELISTS 2);

and

CREATE TABLE mytable (col CHAR(1)) STORAGE (FREELISTS 4 FREELIST GROUPS = 2);

regards,
Sinardy

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sinardy Xing Sent: 30 September 2004 17:29
To: oracle-l_at_freelists.org
Subject: Tuning question: FREELIST GROUPS

Hi all,

Why we need FREELIST GROUPS?

What are the differents (in terms of advantages) between

CREATE TABLE mytable STORAGE (FREELISTS 2);

and

CREATE TABLE mytable STORAGE (FREELISTS 4 FREELIST GROUPS 2);

regards
Sinardy
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 30 2004 - 04:28:50 CDT