Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Increase FREEIST w/o drop objects--sorry for the previous garbage code

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

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Mon, 4 Oct 2004 08:45:48 -0500
Message-ID: <358728A276824E419580403633AABFD0021F62AB@INDYSMAIL03.am.thmulti.com>


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.

> 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
Received on Mon Oct 04 2004 - 08:41:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US