One good ratio: R = S + W....
Mogens
Don Granaman wrote:
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" <[EMAIL PROTECTED]>
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
