RE: Increase FREEIST w/o drop objects--sorry for the previous garbage code
- From: "Thomas Jeff" <jeff.thomas@xxxxxxxxxxx>
- To: <tanel.poder.003@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Oct 2004 08:45:48 -0500
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der
Sent: Saturday, October 02, 2004 4:42 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>
To: <sjhussain@xxxxxxxxxxxxxxx>
Cc: <chzhu@xxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>; =
<oracle-l-bounce@xxxxxxxxxxxxx>; <sinardyxing@xxxxxxxxxxxxx>
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.
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
