High Wait for 'Latch: Query Server Process' and 'DFS Lock Handle'
Last updated on FEBRUARY 02, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11B1 [Release 11.1 to 12.1]
Information in this document applies to any platform.
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 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|
Table or index degree of parallelism has been altered.
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