>> Oddly enough, no complaints from users. I signed up for but missed the presentation because I got pulled into a meeting with a manager of an application who was complaining about his database buffer hit ratio... ok.. not really, but I did get pulled into a meeting. I assume that one of the points of the presentation was that the users are one gauge of performance and I'd agree with that. Also, there is no criticism intended in this post, just a thought or two. I'd like to make the point that sometimes users just get used to lousy performance, and after a while they just stop complaining because they are ignored or management does not push this information forward...(or perhaps the work environment is not conducive to user feedback) so the users figure out how to live with it. So, sometimes, we don't get that feedback. Then there is the issue of defining what slow is... the user tells me the application is slow, but what does that really mean? So many times I've gotten this type of response that it's slower this week than last week but when you try to get them to quantify the statement they can not. That being the case, we need a few thermometers to alert us to potential performance improvement opportunities. It is in the class of a thermometer that I put the buffer cache hit ratio. It's just one of many indicators. By itself it means little or nothing, but accompanied by additional evidence that there are some performance improvements to be gained, it is useful. I'll be looking up the archived presentation soon!! RF
Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -----Original Message----- Sent: Thursday, August 08, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Someone send me this after the presentation. He got the point: FYI: My production SAP system has a BHR of 65%. The only complaints are from SAP analysts that say it's too low. Oddly enough, no complaints from users. :) ----- Original Message ----- To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L Sent: Thursday, August 08, 2002 5:43 PM Guys, I had this dream that I missed the webcast - which I did. However, someone said it wasn't very interesting but the conversation of the people (gurus) left over was very interesting as there was good solid evidence that he was incorrect and db_block_buffers do matter. Kind of inline with the discussion about redos yesterday and my indexing/partition issues - hmmm. -----Original Message----- <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, August 08, 2002 1:38 AM To: Multiple recipients of list ORACLE-L Www.precise.com, go to Events->webcasts... On 2002.08.08 00:53 Madhusudhanan Sampath wrote: > Are transcript documents available anywhere? > > Regards > Madhusudhanan S > > > > _________________________________________________________________ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx <http://photos.msn.com/support/worldwide.aspx> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> > -- > Author: Madhusudhanan Sampath > 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). > -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Mladen Gogala 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: Freeman, Robert 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).
