Oracle-L: Re: ASSM & buffer busy waits ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 16 Apr 2003 13:23:46 -0800
Message-ID: <F001.005835B3.20030416132346@fatcity.com>

The theory is that most BBWs are due to
table block contention on concurrent inserts because of a shortage of freelists - and ASSM is supposed to supply a relatively large number of different insertion points randomly distributed by process id.

Do you get any useful information from v$segstat ? Is it possible you are getting BBWs on L1 blocks ?

Can you tell us -

How many nodes ?

How many concurrent insert processes per node ?

If you get any clues from v$bsp, or v$dlm_misc.

Are there any significant DFS wait events in v$session_event ?

Regards

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

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr

One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 22nd
____USA_(FL)_May 2nd
____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html

____UK_(Manchester)_May x 2
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

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> Sent: 16 April 2003 21:48

> Call me novice ... but what's the relationship between BBW and
> ASSM(anagement)? I have ASSM tablespaces in RAC, and I see BBW's all
the
> time.
>
> Raj
> --------------------------------------------------------------------

> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>

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

Received on Wed Apr 16 2003 - 16:23:46 CDT