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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sinardy Xing Sent: Thursday, September 30, 2004 5:29 AM 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 - 09:55:24 CDT