Support Article
Hung threads in Production Environment
SA-44694
Summary
There are lot of hung threads found in production environment. System is getting slow because of hung threads.
Poor performance is observed in production.
Error Messages
Not Applicable
Steps to Reproduce
Not Applicable
Root Cause
Due to increase in hung threads in production environment which are related to the database, degradation in performance was observed.
Resolution
Here's the explanation for the behavior:
PRPC does not specify storage explicitly for lob.
This is cross-platform practice except ZOS. That means the storage goes with platform default.
For Oracle 11g, the default is basicFile. Oracle 12c has switched the default to secureFile.
There are some Oracle high water contention enqueue bugs reported.
However, given the size of work table (130GB) and growth pattern, partition can be considered if not yet.
Dedicated tablespace/storage at partition level will improve further performance.
Published February 12, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.