Yes I think many people often forget the simple value in the tracking of
values and watching for discrepancies. I have a simple script that I used
on a HP box that i was SA on that simply collected a bunch of simple stats
from sar and vmstat and mailed them to me. I was able to prove many times
that the changes that had been requested helped or hurt the system.
--
=================================================
Peter McLarty E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant WWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, Australia Mobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=================================================
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=================================================
Mincom "The People, The Experience, The Vision"
=================================================
Connor McDonald <hamcdc_at_yahoo.co.uk>
Sent by: root_at_fatcity.com
23-04-2002 09:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Fax to:
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
> 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).
--
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.
--=_mixed 00196C754A256BA4_=--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Peter.McLarty_at_mincom.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).
- application/octet-stream attachment: STG25003
Received on Tue Apr 23 2002 - 00:38:22 CDT
