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

 

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 01 14:41:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.