enq: ZZ - update hash tables wait event
Hi,
We are getting some high wait event for enq: ZZ - update hash tables.
Foreground Wait Events
- s - second, ms - millisecond - 1000th of a second
- Only events with Total Wait Time (s) >= .001 are shown
- ordered by wait time desc, waits desc (idle events last)
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
|---|---|---|---|---|---|---|
| db file sequential read | 1,701,811 | 0 | 7,993 | 5 | 7.45 | 23.22 |
| enq: ZZ - update hash tables | 1,160,004 | 0 | 3,521 | 3 | 5.08 | 10.23 |
| reliable message | 3,067,194 | 0 | 1,489 | 0 | 13.42 | 4.32 |
| log file sync | 226,038 | 0 | 1,025 | 5 | 0.99 | 2.98 |
Can someone please advise how we can cater this situation.
Release 11.2.0.3.0
0