High "Latch Free" wait in AWR and the problem latch is with "KFMD SGA" (Doc ID 1644377.1)

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.

Symptoms

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

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