hi Mike,
Go to my site (www.oracledba.co.uk), then Tuning =>
Custom Hit Ratio
Enjoy!
Cheers
Connor
- "Vergara, Michael (TEM)" <mvergara_at_guidant.com>
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 <cary.millsap_at_hotsos.com> 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.
> > cary.millsap_at_hotsos.com
> > 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"
> <ORACLE-L_at_fatcity.com>
> > 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:hamcdc_at_yahoo.co.uk]
> > > > 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 <john.kanagaraj_at_hds.com>
> 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:mark_at_cool-tools.co.uk]
> > > > > > 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: mvergara_at_guidant.com
>
> 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: ListGuru_at_fatcity.com (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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Thu Apr 25 2002 - 06:58:21 CDT
