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

Brilliant. I have now started the YODA paper and have put these three acronyms in there with your names attached.

Mogens

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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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