Re: Stuck threads

Posted by ErmanArslansOracleBlog on Apr 02, 2020; 11:48am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Stuck-threads-tp8190p8196.html

Server hang?
It sounds like you have a different issue.
So, probably your stuck threads were still doing some work  while their state was set to stuck.. Stuck threads doesn't always mean they are waiting/they are hang.. They may be actively waiting as well..
For ex: a thread may initiate a process for creating a PDF report.. Imagine a thread calling SAP to build a report.. So that thread will wait for that report in sleep mode.. It may be identified as stuck while it is waiting..
You should investigate the reason behind that hand and it is probably due to high load on your server.
Stuck threads may be the  cause but they can also be the result..

Review your environment. DB, OS , your WLS (logs) and your code..  Find the reason behind that high load and stuck threads on your server.