• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1118
  • Last Modified:

Resolving "enqueue wait" & "enqueue timeout"

Is increasing enqueue_resources the
only way to resolve "enqueue wait"
and "enqueue timeout" problems??

We currently have around 100 concurrent
users in our database, although I've
set enqueue_resources up to 50000 already (max value is 65535), but we're still seeing over 300 occurences (each)of EW and ET accumulated in a week's time.

Am I worrying over nothing??  Thx
0
mindless
Asked:
mindless
1 Solution
 
mshaikhCommented:
This is no bad at all. We have several database that average 100-200 enqueue waits a day.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now