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

"Clouded this boy' response time is"

Niall Litchfield wrote:
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).