U might check Metlink DOC ID:Note:1029850.6
Subject:Freelists and Freelist Groups
HTHU
Ankur Shah
Oracle DBA
DHR-GA
> 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
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 30 2004 - 10:29:29 CDT