The configuration of our system is something like 'Client---Middleware---Oracle Database'.The Client sends some request to the Middleware which in turns talks to the Oracle DB,does some processing and return the request.But in the last few days when we build a new Middleware box the query seems to be running forever.We are using Oracle 8.1.6 on Windows 2000 server.
Any help/idea?