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
> feedback on
> > any "new" tools
> > that were launched, or any tools that made a
> significant
> > impact at IOUG?
> >
> > This is purely for "vendor awareness" for myself,
> as I like
> > to keep up to
> > date on anything new in and around our particular
> market
> > place.. If anybody
> > saw something and thought "wow!", I'd be
> interested in
> > hearing about it. If
> > you would like to contact me directly about this -
> please
> > feel free, though
> > I feel the list *could* also benefit from this..
> >
> > Cheers
> >
> > Mark
> >
> >
> ===================================================
> > Mark Leith | T: +44 (0)1905 330 281
> > Sales & Marketing | F: +44 (0)870 127 5283
> > Cool Tools UK Ltd | E: mark_at_cool-tools.co.uk
> >
> ===================================================
> > http://www.cool-tools.co.uk
> > Maximising throughput & performance
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Mark Leith
> > INET: mark_at_cool-tools.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).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: John Kanagaraj
> INET: john.kanagaraj_at_hds.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 Mon Apr 22 2002 - 18:44:18 CDT
