RE: Increase FREEIST w/o drop objects--sorry for the previous garbage code

Speaking of freelists, is checking v$segment_statistics for buffer busy = waits a valid
indication of possibly needing more freelists? For example, the = following buffer busy waits=20
occurring for the selected objects are the values are for one night of = batch processing:

OBJECT_NAME                    OBJECT_TYPE             VALUE
------------------------------ ------------------ ----------
ORDER_SHIP                     TABLE PARTITION       1106138
ORDER_SHIP                     TABLE PARTITION       1270775
SALES_ORDER                    TABLE PARTITION       1589732
SALES_ORDER                    TABLE PARTITION       1723766
ORDER_SHIP                     TABLE PARTITION       1935923
SALES_ORDER                    TABLE PARTITION       2411662
ORDER_SHIP                     TABLE PARTITION       2715558

Thanks,
Jeff T.

                                                                         =
                       =20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel P=F5der Sent: Saturday, October 02, 2004 4:42 PM To: oracle-l_at_freelists.org
Subject: Re: Increase FREEIST w/o drop objects--sorry for the previous = garbage code

ASSM - Automatic segmnet space management.

There is no such thing as freelist for an ass-managed segment, free = space is managed using internal indexes and bitmaps within them in ASSM.

If interested in more, check =
http://integrid.info/Poder_Freelists_vs_ASSM.ppt for quick review..

Tanel.

• Original Message -----=20 From: "zhu chao" <zhuchao_at_gmail.com> To: <sjhussain_at_alfransi.com.sa> Cc: <chzhu_at_ebay.com>; <oracle-l_at_freelists.org>; = <oracle-l-bounce_at_freelists.org>; <sinardyxing_at_bkgcomsvc.com> Sent: Saturday, October 02, 2004 12:45 PM Subject: Re: Increase FREEIST w/o drop objects--sorry for the previous = garbage code

> There are many site don't use the new features , like ASM. There are a =

> lot of ASM related bugs in metalink. So it is still meaningful to tune =

> freelists/groups even in 9i.

>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l