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: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 23-04-2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 <[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 > 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: [EMAIL PROTECTED] > > > =================================================== > > http://www.cool-tools.co.uk > > Maximising throughput & performance > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Mark Leith > > 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). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: John Kanagaraj > 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). -- 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.
STG25003
Description: Binary data
