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