RE: free buffer waits & DISK I/O

Is it just me, or is something wrong with this site? I would love to see a copy of this paper. When I go to this url and click on the "session search", I get an "error document 404".

Is there another way to get to the open world papers?? Thanks.
Barb

> ----------
> From: Post, Ethan[SMTP:Ethan.Post_at_ps.net]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, December 17, 2001 4:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: free buffer waits & DISK I/O
>
> Can't answer your question but sounds like you might benefit from reading
> Gaja Krishna Vaidyanatha's paper (Tuning Oracle Without Cache Hit Ratios)
> at
> the Open World site (http://www.oracle.com/openworld/us/conference) or
> reading Oracle Tuning 101 (book) by the same author. Sounds like you had
> a
> problem and immediatly threw memory at it as opposed to working to
> identify
> the SQL that was actually causing the problem. You saw a small
> improvement
> but not as much as you hoped. This is exactly the type of thing Gaja
> talks
> about in the papers and books.
>
> - Ethan
>
> -----Original Message-----
> Sent: Monday, December 17, 2001 3:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
> INET: Ethan.Post_at_ps.net
>
> 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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.com

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