Re: Performance analysis (enqueue and buffer busy waits)

From: Pablo ksksksk <p_rodri99_at_yahoo.es>
Date: Tue, 14 Aug 2001 12:48:46 -0700
Message-ID: <F001.0036A6E2.20010814125345@fatcity.com>

Hi Deepak:

thanks for answering, I've already identified the objects incurring into BBW but I also know that the p3 parameter for the BBW is "0" !! (this means that the session A had to wait because the block that session A needed, was being read from disk to Buffer Cache by session B).

I don't see how can it help to add more freelists to this table?
I think this would have sense if p3=1016 or 1012 maybe.
I think that in this case there's no contention in the segment header.

what do you think?
anyone else has any ideas?

thanks

Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: p_rodri99_at_yahoo.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Tue Aug 14 2001 - 14:48:46 CDT