Re: Tuning question: FREELIST GROUPS
- From: Raj Kumar <raj.anuradha@xxxxxxxxx>
- To: sinardyxing@xxxxxxxxxxxxx
- Date: Thu, 30 Sep 2004 13:03:15 +0300
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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
