My Oracle Support Banner

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

Last updated on DECEMBER 08, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


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


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
 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"

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