Home » RDBMS Server » Performance Tuning » Health Check - on Enqueues
Health Check - on Enqueues [message #65265] Fri, 09 July 2004 06:11
CMT
Messages: 1
Registered: July 2004
Junior Member
Question: Is there any rule / formula for evaluating and grading (Good/poor/error)the v$sysstat values relating to CLASS - Enqueues

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

then ...

Thanks,

CMT

 
Previous Topic: Poor performance in database while reporting and batch processing
Next Topic: Session parametres
Goto Forum:
  


Current Time: Sun Sep 27 22:38:33 CDT 2020