Re: Tuning question: FREELIST GROUPS

Dear Sinardy,

Freelist Groups is for Oracle Parallel Server or RAC.

It reduces contention on the segment header block, and reduce 
inter-instance "pinging", at the cost of excessive disk space
consumption.

Please refere Oracle Concepts guide for more details.

Thanks and regards
Raj


On Thu, 30 Sep 2004 17:29:13 +0800, Sinardy Xing
<sinardyxing@xxxxxxxxxxxxx> wrote:
> 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: