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.shtm
--
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).
Received on Sat May 24 2003 - 00:46:41 CDT
