free buffer waits & DISK I/O

From: Pablo ksksksk <p_rodri99_at_yahoo.es>
Date: Mon, 17 Dec 2001 14:03:22 -0800
Message-ID: <F001.003DE846.20011217135528@fatcity.com>

HI list.

I was tuning a database (Oracle 7.3.4) that was waiting for "free buffer waits" mostly.
I tuned DBWn batch size properly (increased it till 4MB) as well as buffer cache size (it's 600MB now) too and I got some improvement but I didn't get a major improvement.
But some weeks ago, when we changed the disk array
(from one symmetrix to another) and made an appropiate

disk distribution (to eliminate contention), "free buffer waits" went down (almost desappeared). We didn't change anything else.

I noticed that the "avg db file parallel write" changed from 150ms to 30ms.

Can someone explain me why "free buffer waits" dissapeared?

TIA

---

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 Mon Dec 17 2001 - 16:03:22 CST