Oracle-L: RE: 9i / 9iRAC : Segment_Space

From: Michael Kline <mkline1_at_comcast.net>
Date: Thu, 19 Dec 2002 13:35:10 -0800
Message-ID: <F001.0051F053.20021219133510@fatcity.com>

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOBOh the good old days when at the state
government they decided to call us
Bureau of Application Development And System Software

Yep, until the initials became apparent.. I think it lasted about 2-4 weeks, and they changed it.

Maks.
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Loughmiller, Greg Sent: Thursday, December 19, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

:-0

Our ASS managment does a lot of thrashing lately...

It's close enuf to Friday and a 2 week vacation as well..... -----Original Message-----
From: Koivu, Lisa [mailto:Lisa.Koivu_at_efairfield.com] Sent: Thursday, December 19, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

ASS Management? I'm snickering, I know it's juvenile humor, but... LOL! Let me tell you, my ASS is not on the Free List. And thrashing? I'll leave that one alone!

Sorry everyone. Couldn't resist. Is it Friday yet...

-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk] Sent: Thursday, December 19, 2002 1:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Depending on your circumstances, ASS Management can eliminate severe contention on the freelists / freelist groups area. However, because Oracle is overgenerous with its allocation of bitmap blocks (which may turn out to be in excess of 1% of your database), you may end up thrashing your system because most of your buffer space is flooded with hot BMBs and the data has to keep thrashing on and off disk.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

    Coming soon a new one-day tutorial:
    Cost Based Optimisation
    (see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 19 December 2002 17:51

>We were the other way around in our testing lately:-)
>
>We turned on auto space management to remove the contention.
Afterwards-we
>removed quite a bit of header block/free list contention..
>
>anyway, more tests to follow
>
>-----Original Message-----
>Sent: Thursday, December 19, 2002 10:09 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>As part of a RAC benchmark with 9.2 we had faced severe LOCKING
>on setting segment space management AUTO & had to REMOVE it
>
>HTH
>

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net     --
    Author: Jonathan Lewis
      INET: jonathan_at_jlcomp.demon.co.uk

    Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
    San Diego, California        -- Mailing list and web hosting services
    ---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Kline
  INET: mkline1_at_comcast.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 19 2002 - 15:35:10 CST