To: <SinardyXing@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 30 Sep 2004 10:59:32 -0400
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
