RE: Tuning question: FREELIST GROUPS

Multiple FREELIST GROUPS were originally designed for parallel server =
(aka OPS, aka RAC), but
on very heavy DML databases, there can be some benefit to setting =
multiple freelist groups on
single instance Oracle, as well.

Go to MetaLink, and check out Freelist Management with Oracle8i, by =
Stephan Haisley!  It's excellent!

-Mark

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing
Sent: Thursday, September 30, 2004 5:29 AM
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: