user12204272 wrote:therefore you logically conclude that the root cause is within the DB.
Hi Thanks for the reply,
Actually the same code is running in both test and Production. And after 4 month of the release in test suddenly this issue started in test, but this issue is never noticed in the Production.
user12204272 wrote:Are you claiming that each & every line on code running on the Test server is 100% identical to Prod?
No I am not saying issue is with the db. We are analyzing from both end java and oracle. As we have 4 app servers and from server logs it look like all the four app servers stop getting notifications at the same time from the db which is a common for all 4 app servers. Hence can't confirm if app server code is having issue. All this piece of notification code was working fine since 2009 in both test and PROD, and suddenly
stop working for test without change in code , this is the reason we are suspecting some thing may be wrong at db end.So explain again what changed in the DB Server that could account for the observed change in application behavior.