hi Mike, Go to my site (www.oracledba.co.uk), then Tuning => Custom Hit Ratio
Enjoy! Cheers Connor --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > Ok...ok...ok...enough talk... can somebody PLEASE > publish a > reference location of this script? > > Thanks, > Mike > > > -----Original Message----- > Sent: Wednesday, April 24, 2002 8:39 AM > To: Multiple recipients of list ORACLE-L > please > n > > > it was also mentioned at the Oracle of Oracles > closing session, in the > "top 10 things I learned in San Diego" :) > > > --- Cary Millsap <[EMAIL PROTECTED]> wrote: > > Might have been Dave too, but I mentioned it in my > "Misunderstandings > > About Oracle Internals" talk at IOUG on Tuesday... > > > > > > Cary Millsap > > Hotsos Enterprises, Ltd. > > [EMAIL PROTECTED] > > http://www.hotsos.com > > > > > > -----Original Message----- > > Sent: Monday, April 22, 2002 10:58 PM > > To: Multiple recipients of list ORACLE-L > > n > > > > I think it was Dave Ensor... > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > > Sent: Monday, April 22, 2002 6:30 PM > > > > > > > Hi Connor, > > > > > > Somebody (I think it was Cary) mentioned your > little PL/SQL > > procedure > > that > > > will provide any required CHR. So you are > famous, even if you were > > not > > > present :) > > > > > > And yes, without seeming to migrate to the CHR > camp, there is some > > merit > > in > > > what you are saying. However, I would suggest > that tracking > > 'normal' > > delta > > > values of 'cache buffer chain' gets, misses, > spins and sleeps from > > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of > 'table scan rows > > gotten' > > vs > > > 'table fetch by rowid' would be a better 'ratio' > than the CHR which > > will > > > only serve to feed a myth. The former would give > you some > > indication > > of > > LIO > > > (and the stress it causes on the system) and the > latter will > > indicate > > raw > > > requirements that were met but were the ones > that drove PIO.... As > > for > > me, > > I > > > detect changes in the following SQL and page out > to an on-call DBA > > when > > some > > > set limits are exceeded: > > > > > > select event, count(*) from v$session_wait > > > group by event; > > > > > > This does show the 'current' bottleneck and I > still remain true to > > the > > > calling of OWI!! > > > > > > John Kanagaraj > > > Oracle Applications DBA > > > DBSoft Inc > > > (W): 408-970-7002 > > > > > > Grace - Getting something we don't deserve > > > Mercy - NOT getting something we deserve > > > > > > Click on 'http://www.needhim.org' for Grace and > Mercy that is > > freely > > > available! > > > > > > ** The opinions and statements above are > entirely my own and not > > those > > of > > my > > > employer or clients ** > > > > > > > > > > -----Original Message----- > > > > From: Connor McDonald > [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, April 22, 2002 4:44 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: Anything new from IOUG? + "OWI" > Born!! > > > > (Anjo/Mogens, please > > > > n > > > > > > > > > > > > I still like to recommend the buffer cache hit > ratio > > > > because its so easy to please customers with > an > > > > improvement - A plsql routine to generate any > desired > > > > hit ratio on a running system is freely > available for > > > > download from my site... a consultants dream! > :-) > > > > > > > > But, serious hat on temporarily, there IS > still a use > > > > for the buffer hit ratio as a "delta" > measurement. > > > > What I mean by this is that you measure it > every 'n' > > > > mins/hrs/whatever and store it. When it > displays a > > > > massive dip or a massive increase (ie > something out of > > > > the ordinary for *your* system), then whilst > it > > > > doesn't necessarily mean anything is wrong - > it DOES > > > > mean that something has changed in your > system, which > > > > is a good prompt to do some investigation.. > > > > > > > > hth > > > > connor > > > > > > > > --- John Kanagaraj <[EMAIL PROTECTED]> > wrote: > > > > > Mark, > > > > > > > > > > This is from a first-timer at IOUG, so I may > be way > > > > > off here. > > > > > > > > > > A lot of marketing blurb was thrown out at > IOUG > > > > > (probably a lot less than > > > > > usual, and *much* less than Oracle OpenWorld > in any > > > > > case!). As for tools, > > > > > many vendors were flogging the same ones, > improved > > > > > versions maybe. One which > > > > > did make us say 'wow' was StorageXpert from > Quest. > > > > > IMHO, this is an > > > > > excellent tool, engineered by our very own > Gaja. I > > > > > believe details are at > > > > > the Quest site at www.quest.com. If you have > EMC > > > > > disks and are facing > > > > > performance problems, I believe there is the > best > > > > > there is. (Or even if you > > > > > have other storage devices, it would still > give you > > > > > the hotspots). > > > > > > > > > > And NO, I do NOT work for Quest, nor have > Quest > > > > > stock! > > > > > > > > > > And for others, I believe this was a major > turning > > > > > point and an eye-opener > > > > > as far as the Wait Interface goes (This has > > > > > (un)officially been renamed to > > > > > OWI as per Kirti's slides :-). Most > attendees 'saw > > > > > the light' as far as CHR > > > > > (Cache Hit Ratio) goes, and there were two > distinct > > > > > camps after the first > > > > > few days - the 'CHR' and 'OWI'. No prizes > for > > > > > guessing who won the day! The > > > > > massive number of defections and the > absolute > > > > > absense of > > > > > CHR-based-discussions at the Performance > round > > > > > tables was clear evidence > > > > > that OWI is here to stay! (Mr. R might still > rewrite > > > > > that book sooner than > > > > > later!) > > > > > > > > > > About 20 Listers met for dinner on Sunday > night (and > > > > > again in a larger group > > > > > at the SeaWorld bash). The meeting was > characterized > > > > > by geek-talk such as > > > > > 'Can you fit us all in one extent?' i.e. > 'can we all > > > > > sit at one table?'), > > > > > 'Please coalesce' - 'please move in so that > more > > > > > people can fit into the > > > > > aisle seats'. > > > > > > > > > > Oh Boy, that WAS a lot of fun! > > > > > > > > > > John Kanagaraj > > > > > Oracle Applications DBA > > > > > DBSoft Inc > > > > > (W): 408-970-7002 > > > > > > > > > > Grace - Getting something we don't deserve > > > > > Mercy - NOT getting something we deserve > > > > > > > > > > Click on 'http://www.needhim.org' for Grace > and > > > > > Mercy that is freely > > > > > available! > > > > > > > > > > ** The opinions and statements above are > entirely my > > > > > own and not those of my > > > > > employer or clients ** > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Mark Leith > [mailto:[EMAIL PROTECTED]] > > > > > > Sent: Monday, April 22, 2002 4:58 AM > > > > > > To: Multiple recipients of list ORACLE-L > > > > > > Subject: Anything new from IOUG? > > > > > > > > > > > > > > > > > > Hi All that recently attended IOUG. > > > > > > > > > > > > If you don't already know - I sell "tools" > for > > > > > Oracle. > > > > > > (delete this now if > > > > > > you want to DG! ;P) > > > > > > > > > > > > I was just wondering if anybody at IOUG > had any > > > === message truncated === > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Vergara, Michael (TEM) > 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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
