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:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
