My Oracle Support Banner

Top 5 Database Hang Issues due to ASM (Doc ID 2248393.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Purpose

 The purpose of this note is to provide a summary of the Top 5 Database hang /performance  due   to ASM .

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Details
 Issue #1:High Load On Server from Process Ora_onnn
 Issue #2:High 'ksv master wait' And 'ASM File Metadata Operation' Waits In Non-Exadata 11g
 Issue #3:LGWR Spinning and Waiting for "log file parallel write" When Redologs are on ASM
 Issue #4: ASM Communication Error ORA-15055 ORA-21561
 Issue #5:ORA-600 [kfnsInstanceReg00] and long waits on "ASM FILE METADATA OPERATION"
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.