My Oracle Support Banner

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

Last updated on JUNE 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.6.0 and later
Oracle Database - Personal Edition - Version 8.1.6.0 and later
Oracle Database - Standard Edition - Version 8.1.6.0 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.
***Checked for relevance on 12-AUG-2014***

Purpose

 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).

Scope

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

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!


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