RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n

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
> > > 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).
> >
> --
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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).