JDBC queries to Oracle database from JBoss EAP are slowing down

Issue

• While taking thread dump on app server side , extremely high cpu usage on the database side and longer waits on the app server side

       java.lang.Thread.State: RUNNABLE
            at java.net.SocketInputStream.socketRead0(Native Method)
            at java.net.SocketInputStream.read(SocketInputStream.java:129)
            at oracle.net.ns.Packet.receive(Packet.java:239)
            at oracle.net.ns.DataPacket.receive(DataPacket.java:92)
            at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:172)
            at oracle.net.ns.NetInputStream.read(NetInputStream.java:117)
            at oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
            at oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
            at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1023)
            at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:999)
            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:584)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
            at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
            at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
            at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
            - locked <0x00002aab0876bc10> (a oracle.jdbc.driver.T4CConnection)
            at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
            at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
            at atg.commerce.catalog.custom.TreeWalkUpdateService$UpdateRange.getChangeIds(TreeWalkUpdateService.java:2645)
            at atg.commerce.catalog.custom.TreeWalkUpdateService$UpdateRange.run(TreeWalkUpdateService.java:2719)
            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
            at java.lang.Thread.run(Thread.java:619)