RE: Tuning question: FREELIST GROUPS
- From: "Sinardy Xing" <SinardyXing@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Sep 2004 17:39:04 +0800
again sorry for the typo :)
I am curious to know the advantages of using FREELIST GROUPS, why we =
need to group the freelists?
and how the freelist group can improve the performance..
Thanks so much
regards,
Sinardy
PS: I love Microsoft because the F7 :)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing
Sent: 30 September 2004 17:33
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Tuning question: FREELIST GROUPS
Hi all,
Why we need FREELIST GROUPS?
What are the differents (in terms of advantages) between
CREATE TABLE mytable (col CHAR(1)) STORAGE (FREELISTS 2);
and
CREATE TABLE mytable (col CHAR(1)) STORAGE (FREELISTS 4 FREELIST GROUPS =
=3D
2);
regards,
Sinardy
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing
Sent: 30 September 2004 17:29
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
