RE: Tuning question: FREELIST GROUPS
- From: Ankur Shah <desert_moon@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 30 Sep 2004 08:33:50 -0700
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@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
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
