High Wait for 'Latch: Query Server Process' and 'DFS Lock Handle'
Last updated on FEBRUARY 02, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2B1 [Release 11.1 to 12.1]Information in this document applies to any platform.
Symptoms
Queries running slow with high waits for 'latch: query server process' and 'DFS lock handle'
Top 10 Foreground Events by Total Wait Time
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| DFS lock handle | 1,336 | 29.4K | 22043 | 52.3 | Other |
| latch free | 6,200 | 25.7K | 4137 | 45.5 | Other |
| DB CPU | 463.3 | .8 |
Latch Activity
| Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
|---|
| query server process | 80,297 | 4.01 | 2.68 | 25830 | 2,104 | 0.29 |
Changes
Table or index degree of parallelism has been altered.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms