Please enable JavaScript.
Coggle requires JavaScript to display documents.
STUCK Threads during Rollback (To Fix (Option #1 (Maximum_Resource…
STUCK Threads during Rollback
To Fix
Option #1
Maximum_Resource_Requests_on_a_Server=100
Self_Tuning_Thread_Maximum_Pool_Size = 500
oracle.jdbc.ReadTimeout = 36000000
Option #2
Fix the long query (PSUPSP-9820)
Option #3
Create ticket to Alexey M
Affected Operations
TOMS Reports (duration 2h+)
Long Transactions (JTA timeout 7200 sec)
Observed Issues
Long Running Queries (PSUPSP-9820)
Lost connectivity between app & db (PSUPSP-9691)
TODO:
Ask TFN about FW between app & db
Go throughout points related to the case when FW is present
Check JDBC Driver Version on PROD (RETPSM-657)
Identical