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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing
Sent: 30 September 2004 17:29
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: