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

Not to forget

Very
Antiquated
Diagnosis
Encompassing
Ratios

Measure response, you must.

Niall

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> Connor McDonald
> Sent: 24 May 2003 06:47
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Anything new from IOUG? + "OWI" Born!!
> (Anjo/Mogens, please n
>
>
> Some other performance related algorithms and their
> acronyms:
>
> High
> Availability
> Network
> Storage
> Optimised (for)
> Low
> Overheads
>
> or "HANSOLO"
>
> Complete
> Heuristic
> Event-driven
> Wait-interface
> Broker (for)
> Aggregation (of)
> CPU and
> Cost
> Approximations
>
> or "CHEWBACCA"
>
> Cheers
> Connor
>
> --- Mogens_Nørgaard <mln_at_miracleas.dk> wrote: > Today
> Martin Berg (an ex-Premium Services guy, who's
> > now in Oracle
> > Consulting, and who invented the absolutely
> > brilliant concept of
> > throw-away of rows) and I had a looong meeting where
> > we came up with the
> > YODA concept.
> >
> > It stands for Yapp Overview Diagnostics Analysis.
> > Not pretty, perhaps,
> > but Martin and I can remember it.
> >
> > Here's the deal (and it's of course inspired by
> > Cary, who's a reasonably
> > smart guy for a Texan):
> >
> > R = S + W (roughtly, thanks to Erland and Kolk)
> >
> > This can be measured on three levels:
> >
> > 1. System level. Data taken from v$system_event &
> > v$sysstat.
> > 2. Job/session level. Data taken from
> > v$session_event, v$sesstat -
> > and/or 10046.
> > 3. SQL level. Data taken from 10046.
> >
> > So 1 = O, 2 = D and 3 = A.
> >
> > You can perhaps say something in general - get an
> > overview - using 1
> > (system level). But basically bstat/estat,
> > statspack, MirMon and all
> > that are useless for most practical purposes. So O =
> > Overview.
> >
> > You can certainly find out who's doing what and for
> > how long using 2
> > (session/job level). So D = Diagnostics.
> >
> > And you can find out what's wrong using 3. So A =
> > Analysis.
> >
> > We called it YAPP/ODA. Jonathan Lewis, who's been
> > drinking my whisky for
> > the last three days here in Maaloev, suggested YODA
> > instead. Very good.
> >
> > We also came up with some (I think) new stuff about
> > batchjobs (or OLBP -
> > OnLine Batch Processing), and how to monitor and
> > control them, but I'll
> > let you know when we're done with the whitepaper we
> > decided on the spot
> > to write.
> >
> > Rock'n'roll.
> >
> > Mogens
> >
> > Johnson, Michael wrote:
> >
> > >Well said .... It appears working with users that
> > are experiencing
> > >significant waiting and resolving those have a
> > better ROI than any other
> > >analysis.
> > >
> > >Mike
> > >
> > >-----Original Message-----
> > >Sent: Tuesday, April 23, 2002 3:53 AM
> > >To: Multiple recipients of list ORACLE-L
> > >n
> > >
> > >
> > >There is one ratio that is a far better indicator
> > than any of that fancy
> > >wait analysis stuff - the USR (User Satisfaction
> > Ratio). I usually consider
> > >the system to be optimal if the USR is near 97%
> > (the other 3% are chronic
> > >whiners anyway). Of course, this does not apply if
> > the CEO is in that 3%.
> > >Any CEO waits are considered unacceptable.
> > >
> > >Don Granaman
> > >[OraSaurus]
> > >
> > >----- Original Message -----
> > >To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > >Sent: Tuesday, April 23, 2002 3:33 AM
> > >
> > >
> > >[...]
> > >
> > >
> > >>I would also like to point out that not all 'hit
> > ratios'
> > >>are bad. The FAN hit ratio is a very useful
> > indicator.
> > >>(see http://miracleas.dk/undskyld/fhr.pdf in the
> > short
> > >>term for further details).
> > >>
> > >>
> > >>Jonathan Lewis
> > >>http://www.jlcomp.demon.co.uk
> > >>
> > >>Author of:
> > >>Practical Oracle 8i: Building Efficient Databases
> > >>
> > >>Next Seminar - Australia - July/August
> > >>http://www.jlcomp.demon.co.uk/seminar.html
> > >>
> > >>Host to The Co-Operative Oracle Users' FAQ
> > >>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> > >>
> > >>
> > >
> > >
> > >
> >
> >
>
> =====
> Connor McDonald
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
> "GIVE a man a fish and he will eat for a day. But TEACH him
> how to fish, and...he will sit in a boat and drink beer all day"
>
> __________________________________________________
> It's Samaritans' Week. Help Samaritans help others.
> Call 08709 000032 to give or donate online now at
> http://www.samaritans.org/support/donations.sh> tm
> --
> Please
> see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).