My Oracle Support Banner

No Response from the Server, Does it Hang or Spin? (Doc ID 68738.1)

Last updated on JULY 15, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database - Personal Edition - Version and later
Oracle Database - Standard Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.


 If database operations are 'hanging' it is difficult to tell what is happening or what to do about it. This article helps DBA's to identify whether the process is hanging (where nothing is moving) or spinning (when a process gets into a (possibly infinite) loop).


 This article is intended for Oracle Support Analysts , Oracle Consultants and Database Administrators.


To view full details, 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 a vibrant support community of peers and Oracle experts.