The application connecting to the Oracle RAC cluster experienced performance issues due to resource constraints, causing unresponsiveness. Troubleshooting artifacts were collected and analyzed using yCrash, revealing that 46% of threads were blocked waiting for database responses. After escalating to the DBA, resource adjustments resolved the slowdown, restoring normal application function.
The article discusses thread activity classification in WebLogic server, used by Oracle technologies. It details five classifications: STUCK threads work beyond the configured timeout, HOGGER threads are held by requests or exceed execution time, ACTIVE threads process requests, STANDBY threads wait to be activated, and IDLE threads have no assigned work.