Hi Prasad,
'default task-33204' thread is stuck on read0() method in sun.nio.ch.FileDispatcherImpl file. Before getting stuck, this thread obtained 5 locks (java.lang.Object lock, oracle.jdbc.driver.T4CConnection lock...) and never released it. Due to that 2 threads are BLOCKED as shown in the below screenshot. If threads are BLOCKED for a prolonged period, your application can become unresponsive. Stacktrace of thread you already mentioned in question.
Here are few solution to resolve the problem:
By looking at the stacktrace , I suspect you did not set timeout for JDBC connections. If timeout settings are set, calls wouldn't be stuck for this long period. Here are few options:
a. There should certain timeout parameters which you can set at Oracle Connection pool level.
b. You can consider passing following system properties to your JVM. More details about these properties can be found here
- -Dsun.net.client.defaultConnectTimeout
- -Dsun.net.client.defaultReadTimeout
- -Doracle.jdbc.ReadTimeout
Edit your Comment