High "Latch Free" wait in AWR and the problem latch is with "KFMD SGA"
Last updated on APRIL 09, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
The RDBMS version is 10.2.0.5.10
There appears to be a problem associated with latching and latches in the
area of ASM and ASM based storage access.
The database performance is very slow and AWR report shows high "latch free" wait.
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
db file sequential read 9,992,562 424,446 42 47.2 User I/O
latch free 259,684 409,004 1,575 45.4 Other
The same AWR report shows the latch with the highest wait time is
KFMD SGA 1,223,789 23.91 0.66 407959 0
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms