Hello Anjo I just had a tuning session with Dov Hit, from ACS in Israel. He used some of the scripts that you showed him 2 years ago when you did some work for Amdocs. Anyway, after doing some search on the waits, he checked the BCHR and found out that this database has only 40%. That led us on further checks and we found more offending SQL's.
The BCHR has it's place. Just do not measure yourself JUST by it. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 3:03 AM > Hmm, > > Lately? That actually started publicly in 1998 as far as I am concerned ;-) > And acutally long before that. > > Anjo. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, January 12, 2003 11:43 PM > > > > On Friday 10 January 2003 14:48, Mogens Nørgaard wrote: > > > Obviously, we don't know what we're talking about. I can see there's a > > > presentation by Rich Niemich at IOUG-A where he'll address all those > > > idiots who are saying you should ignore the Cash Hit Ratio (and who are > > > all just after making big money on their products - I loved that one). > > > > Or modify the set up of these tools to take action when BCHR > falls...... > > > > > > > > Here's the session info: > > > > Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM > > Venue: Southern Hemisphere 2, Walt Disney World > > Dolphin, Lake Buena Vista, FL > > > > Abstract: Lately, there has been a big push to ignore your > > hit ratio with claims that it is meaningless. This shallow > > minded view (usually by people who sell a tuning tool) ignores > > why people look at hit ratios and what they are looking for. > > This quick tip talk will show you what to look for and why. > > You will definitely know when, where & why to look at your > > hit ratio in the future. > > > > Show you why your hit ratio matters. How to analyze the > > hit ratio. Fallacies by those who want to sell you products > > and tools instead. > > > > > > Shallow Minded ?! > > > > Jared > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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.net > -- > Author: Anjo Kolk > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
