No Response from the Server, Does it Hang or Spin?
(Doc ID 68738.1)
Last updated on DECEMBER 14, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database - Personal Edition - Version 18.104.22.168 and later
Oracle Database - Standard Edition - Version 22.214.171.124 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***
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!