Support Article

Application is performing slow

SA-30537

Summary



Opening a workobject and its child work objects takes about 15 seconds or more.

Error Messages



Thread[WebContainer : 2,5,main]
    java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(SocketInputStream.java:140)
    at oracle.net.ns.Packet.receive(Packet.java:283)
    at oracle.net.ns.DataPacket.receive(DataPacket.java:103)
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)


Steps to Reproduce



Create work object or  approve the covered work objects.

Root Cause



A defect or configuration issue in the operating environment, user is  accessing DB which is remote as appears from WebContainer : 2 thread with its following stack trace and rest of the threads are just waiting for it to release the lock or get completed.

Resolution



User need to revise the connection pool settings.

Max connections : 150
Min connections: 1
Reap time: 120
Aged Timeout: 1200


 

Published November 18, 2016 - Updated November 23, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.