Hi,

v$Sysstat statistics are helpful in giving system wide "Health Check"
indicator how the database is performing.

Question: Is there any rule / formula for
evaluating and grading (Good/poor/error)
the v$sysstat values relating to CLASS - Enqueues statistics

which are:
25 - enqueue requests
22 - enqueue timeouts
23 - enqueue waits
24 - enqueue deadlocks

For example -

1) if 22 + 23 + 24 is over zero then ...

or

2) if 22 + 23 + 24 is a certain percentage of 25


For example for Class Buffer -
there is a system Buffer Cache Hit Ratio formula:
1-('physical reads'/('db block gets')+('consistent gets') )
where for example one can grade the results:
Between 90 - 100 OK
Between 80 - 90 Warning
Between 0 - 80 Error

Is there a rule/formula for Enqueue like my example for Buffer
(I was not able to find in Metalink) ?

Thanks in advance,
CMT