TOTALLY OT: WAS:Re: 9i / 9iRAC : Segment_Space_Management AUTO, with

ASS Management, makes me think of that server I used to work on at the EPA,

DBA to UNIX SA: Did you back Uranus?
UNIX SA to DBA: Yep Uranus was backed up last night.

bwahahahaha

joe

Koivu, Lisa wrote:

> 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).
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

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).